phpMyAdmin Create a database and set user permissions diagrams

First, configure the phpMyAdmin configuration, or you cannot log on.

Then you have to enter the phpMyAdmin under the Libraries directory, modify config.default.php file. Find $cfg[' Servers ' [$i] [' password '] = ',

Modified to $cfg[' Servers ' [$i] [' password '] = ' 123456′;

123456 is the password you want, restart MySQL after the new password takes effect.

The first step: admin rights account Login phpMyAdmin, general with root login

Part II: Create a database to set permissions (if it already exists, you don't need it)

Fill in the database name, database code, I chose the "Chinese-chinese Simplified" code, click to create, the data will be built well

Step Three: Create an administrative user

After creating the database, click on the new database sweiku.com, click the right, a new interface appears, and then click Add new users, such as the above

In this step, it is particularly noted that global permissions do not need to be selected and then executed directly.

Fourth step: Set User rights

Select the appropriate permissions and click Execute