How to use PHPMYADMIN to operate mysql database to add new users and databases_PHP tutorial

1. Create a new database:
After entering the phpmyadmin management interface, find the following text "Create a new database", then fill in the name of the database to be created below, and drop down at the back Select the encoding of the database in the list, such as "utf8_general_ci", and click the "Create" button to create a new database.

2. Create a new account corresponding to this database
Click "Permissions" on the phpmyadmin management interface, open the link, click "Add New User", and you will see "Login Information" on the page that opens ", after entering the user name, host (usually local: localhost), and password, because we now need to configure the permissions of a single database for a single user, we do not select "Global Permissions" here, and then click "Execute" at the bottom ” button to create a new username.

3. Add this database permission to the new user
After adding the user, the top of the management interface will prompt "You have added a new user". We will now give the new user To add permissions, find "Specify permissions by database" below, then click the drop-down list behind "Add permissions in the following databases", select the database, select all under the data, and then select the checkboxes except the bottom three of the structure. Leave all others unchecked, and then click the "Execute" button. This will configure the user's permissions to fully manage the database.

Note:
1. Because we only want to give this user all the permissions to manage this database, but do not have management permissions for other databases, so we must pay attention when configuring permissions.
2. INFORMATION_SCHEMA is an information database that stores information about all other databases maintained by the MySQL server. If you don't want to display it in phpMyAdmin, you only need to set this sentence in config.inc.php (some are config.default.php): $cfg['Servers'][$i]['hide_db'] = 'information_schema';

In addition, if you select the "Grant all permissions to databases starting with username_ (username_%)" option in "User Database" when creating a new user, the new user can create his own database starting with "username_" database.

Originally, Script House had this article, but because the text description of this article is more detailed than the original, the two articles are more effective when combined.
Graphic tutorial on creating Mysql database and independent database account using phpMyadmin

http://www.bkjia.com/PHPjc/321630.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/321630.htmlTechArticle1. Create a new database: After entering the phpmyadmin management interface, find the following text "Create a new database", and then Fill in the name of the database to be created below...