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, select the encoding of the database in the drop-down list, such as "Utf8_general_ci", click "Create" button, This creates a new database.
2. Create a corresponding account for this database
In the phpMyAdmin management interface Click "Permissions", open the link, click "Add New User", in the open page will see "Login Information", enter the user name, host (usually Local: localhost), password, because we are now to configure a single user database permissions, So we don't select "Global Permissions" here, then click the "Execute" button at the bottom to create a new username.
3. Add this database permission for new users
After adding the user, the admin interface will prompt "You have added a new user", we now add permissions to the new user, find "Specify Permissions by Database" below, and then click on the "Add permissions under the following database" drop-down list, select the database, select all the data below, Then select the structure in addition to the bottom three of the check box, the other is not selected, and then click the "Execute" button, so that the user has been configured to fully manage the database permissions.
Note:
1, because we just want to give this user to manage the entire permissions of this database, but there is no other database management rights, so in the configuration of permissions must be noted.
2. INFORMATION_SCHEMA is the information database, which holds information about all other databases maintained by the MySQL server. If you do not want to display in the phpMyAdmin only need to set in config.inc.php (some config.default.php) set such a sentence: $cfg [' Servers '] [$i] [' hide_db '] = ' Information_schema '; In addition, if you are innovating users, select the database (username\_%) that starts with the user name in the user database Grant all permissions option, new users can create their own databases that begin with "username_".
Originally the script House has this article, but because this content text explanation is more detailed than the original, so the two articles combined to see, more effective.
Using phpMyAdmin to create a MySQL database and a separate database account with a graphic tutorial
http://www.bkjia.com/PHPjc/321630.html www.bkjia.com true http://www.bkjia.com/PHPjc/321630.html techarticle 1, New database: Enter the phpMyAdmin management interface, find the following text "Create a new database", and then fill in the following the name of the database to be created, in the following ...
