phpMyAdmin Tutorial: How to create a user, database table using phpMyAdmin

Source: Internet
Author: User
Tags character set continue interface php web development table name how to use phpmyadmin mysql database phpmyadmin

phpMyAdmin as a tool to manage MySQL database, more and more by the development of PHP website builders Welcome, Before that I introduced two phpMyAdmin introductory tutorials: The phpmyadmin3 installation configuration diagram tutorial and the configuration method that allows phpmyadmin null password login, continue phpMyAdmin tutorials today, Describes how to use phpMyAdmin to create a method for adding new users to user rights settings and how to use phpMyAdmin to create database tables.

Before you use phpMyAdmin to manage the MySQL database, make sure that the MySQL service is started, that is,

net start MySQL

phpMyAdmin Tutorial: Creating a usage for adding new users and permission settings

1, log into the phpMyAdmin Management homepage, click on the right above the rights menu, will list the current level of all users and user rights, click Add a new user link to enter the User rights settings interface, you can create new users

phpMyAdmin Create a tutorial on adding new users and setting permissions

In the login information mainly contains the user name, host, password three options, user name Select any user or Use Text field option essence is no different, recommend the use of text fields; If you do not want to set a user password to select a password-free entry

Host has four options: any host (%), local (localhost), using host table (host), using text fields, respectively, to match all hosts; local host only (automatically fill out as localhost) ; Use the host table representation to replace the data in the host table in the MySQL database, not fill in, if the host data is added, this option is invalid; Use a text field to indicate that you are filling out the host information yourself.

  Special Note : The use of host table is very interesting, if you create a host in the table hosts, host Select Host table, you can be mysql_connect ("", "username", "password") Connection MySQL can also be connected to MySQL with mysql_connect ("″, username, password").

There are three choices in the User database column, only creating a database that adds new users, creates a database, grants all permissions, and starts with a username _ (username\_%) Granted all permissions, you can choose according to the MySQL database design needs, here I choose None, that is, only create add new users.

When a new user is created, the Global Permissions column shows usage that the user does not have permission to do so because we have not yet set permissions on the user, so we must authorize the user to create, click on the permission menu, and click Edit Permission on the LEAPSOULCN user Action icon, as shown

phpMyAdmin User Rights settings details

MySQL user rights are divided into four types of data, structure, management, resource constraints, can be set or click on their own to select the implementation can be selected.

If you want to remove the added new users, just check the delete user, click the Add new user under the Delete selected users to the right of the execution button, as shown

phpMyAdmin Delete User Tutorial

If you choose to create a database with the same name as the user and grant all permissions when you add a user, and you do want to delete the database that is managed by this user, you can also check the Delete database option with the same name as the user.

phpMyAdmin Tutorial: How to create and modify a database, data table usage

Using phpMyAdmin to create a database is very simple, phpMyAdmin Admin Homepage is the portal to create a database, as shown

phpMyAdmin Create a database tutorial

Here I set up a database named LEAPSOULCN, while setting the character set to GBK, click the Create button to enter the Create Datasheet management interface

phpMyAdmin Create a datasheet tutorial

Fill in the data table name and number of fields, click to execute, that is, enter the Datasheet field management interface

phpMyAdmin Create a data table field tutorial

Use phpMyAdmin to create the most basic data tables that focus on fields, types, lengths/values, collation (character sets), indexes (Primary\unique\index\fulltext), a_i (auto_increment), field notes, table comments, When creating a table, be aware that the character set is unified, otherwise it can easily cause MySQL to appear garbled.

If you want to use phpMyAdmin to modify the data table structure, you can click on the right database, and then click on the Structure menu, will be listed in the selected data all table information, in the Action column to select the structure of the operation.

How do I use phpMyAdmin to delete a database or datasheet? Just select the appropriate database on the left, then click on the Red Delete menu on the right, that is, to delete the database (drop table), if you want to delete a data table (drop tables), Please select the database on the left and then select the corresponding data table listed in the left database and then click the Delete menu, do not confuse, different levels, delete the menu represents the function is different.

If you want to use phpMyAdmin to modify the database created, select the corresponding database on the left, click the action menu, as shown

Using phpMyAdmin to modify a database

You can use phpMyAdmin to rename the database, create the data table, modify the database character set, and so on, simple and practical.

phpMyAdmin Tutorial: How users are set up to manage permissions on a specific database

You can use phpMyAdmin not only to set the global user rights, but also to set user permissions on a database, but before you do this you must make sure that the user is authorized, otherwise the permission settings for the specific database are invalid.

phpMyAdmin permissions to set the portal there are two ways, one is the phpMyAdmin homepage Permission menu, one is to click on a database, select the right menu, the corresponding user clicks Edit Permission operation access permission settings interface

Use phpMyAdmin to set permissions on a specific database for a specific user

Select specific data, such as LEAPSOULCN database, will automatically jump to the user rights settings interface of this database

Setting specific database permissions by using phpMyAdmin

In this way, it is convenient to enter the permissions setting interface for a particular table by selecting the appropriate datasheet in the specified permissions by table.

So how to use phpMyAdmin to create a user and permission settings, how to use phpMyAdmin to create a Management database table phpMyAdmin Tutorial is finished, the future will continue to improve the use of phpMyAdmin tutorial, Convenient for everyone to better use phpMyAdmin management MySQL database.

  Note : PHP Web Development Copyright, reproduced in the form of links to indicate the original source and this statement, thank you.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.