How to use phpMyAdmin to set permissions for MySQL database users _php instance

First, you need to install the configuration on the server phpMyAdmin

Installation configuration method for details: http://www.jb51.net/article/15330.htm

After installation, came to phpMyAdmin's homepage as shown below:


Second, create a user (how you have created a good user before, you can omit this step)
After you click the permissions shown in the previous illustration, you can see the following image:

Click on the "Add new user" connection to add a new database username
As shown in the following illustration:

third, permission settings
As shown in the following illustration:

Edit Hellen permissions for this user
As shown in the following illustration:

Adding users can also fill in the user's permissions, you can also add users to edit the user's permissions later
These permissions are described in detail below:
1. Data section
SELECT: Means to allow reading of data
Insert: Refers to allowing data to be inserted and replaced
UPDATE: Means to allow change of data
Delete: refers to allowing data to be deleted
File: Refers to allowing data to be imported from data, and allowing data to be exported to a file

2. Structural part
Cteate: Allow creation of new databases and tables
Alter: Allow modifying the structure of an existing table
Index: Allow creation and deletion of indexes
Drop: Allow database and tables to be deleted
Create temporary tables: Allow temporary tables to be created
CREATE VIEW: Allow new views to be created
Show VIEW: Allow query attempts
Create routine: Allow new stored procedures to be created
Alter routine: Allow modification of stored procedures
Execute: Allow query execution
Management and resource limitations This is not explained in detail here, it is generally the administrator root account all the permissions, the above is the ordinary user rights.

Iv. Reload Authorization Table
After modifying user rights, you need to go back to phpMyAdmin's homepage and reload the authorization
as shown in the following illustration:

As long as you understand the user's permissions settings, I believe that your database management operations will be handy.