Using phpMyAdmin to create a separate database account method for MySQL database

Let's Make a concrete demo:

1, first we want to login phpMyAdmin (as the current mainstream development language), do not do demo.

2, create a database, the following figure, in phpMyAdmin (as the current mainstream development language) right window, fill in the database name, point creation can.

For example, here we create a database with the name: Cncmstest
Successful creation will have the following tips:

3, click on the top left corner of the homepage button, back to phpMyAdmin (as now the mainstream development language) main interface:

4. Click "Permissions" on the right side of the main screen to create the database account number.

5, in the Permissions page, we click "Add New User"

6, in this page, we fill in the database to create the user name, the user's access scope, and password.

As shown above, we have filled in the user name: Cncmsuser, the database user only allows local access, host a selection of locally; the password we use automatically generated, the point below "Generate" will generate a random password, and then point "Copy" will automatically fill in the Password box.
The following boxes are not selected, directly pull to the bottom of the page to execute to create a new user.
The database user is successfully created and returns the following page:

7, the most important step, set the user's database access permissions
You can set permissions directly in a page where the database user adds a successful return. Here we choose to specify permissions by database:

As shown above, select the Cncmstest we just created in the list of databases, which automatically enters the permissions settings page for that database.

In the permission settings of the diagram above, we select all the permissions for the data, structure, and administrative permissions. Point execution can be