Home > Article > Backend Development > How to use PHPMYADMIN to operate mysql database to add new users and databases_PHP tutorial
How to use PHPMYADMIN to operate mysql database to add new users and databases_PHP tutorial
- WBOYOriginal
- 2016-07-21 15:38:58834browse
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.
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.
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.
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';
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
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
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：Operating Excel example code in PHP_PHP tutorialNext article：Operating Excel example code in PHP_PHP tutorial