How to Use phpmyadmin to set mysql Database User Permissions

1. install and configure phpMyAdmin on the server

For the installation configuration method, see: http://www.jb51.net/article/15330.htm

After installation, go to the phpMyAdmin homepage, as shown in:


2. Create a user (this step can be omitted if you have already created a user)
After clicking the permissions shown in, you can see the permissions shown in:

Click "Add new user" to add a new database user name.
As shown in:

Iii. permission settings
As shown in:

Edit the permissions of hellen.
As shown in:

You can also enter user permissions when adding users, or edit user permissions after adding users.
These permissions are described as follows:
1. Data Section
SELECT: allows reading data.
INSERT: allows you to INSERT and replace data.
UPDATE: allows you to change data.
DELETE: allows you to DELETE data.
FILE: allows you to import data from data and export data to a FILE.

2. Structure
CTEATE: allows you to create new databases and tables.
ALTER: allows you to modify the structure of an existing table.
INDEX: allows you to create and delete indexes.
DROP: allows you to delete databases and tables.
Create temporary tables: allows the creation of TEMPORARY TABLES
Create view: allows you to CREATE a new VIEW.
Show view: Allow query attempts
Create routine: allows the creation of new stored procedures
Alter routine: allows you to modify stored procedures.
EXECUTE: Allows query execution
Management and resource restrictions are not described in detail here. Generally, all the permissions of the administrator root account are described above as common user permissions.

4. Reload the authorization table
After modifying the user permissions, you need to go back to the phpMyAdmin homepage and reload the authorization.
As shown in:

As long as you understand the user's permission settings, we believe that you will be comfortable with database management operations.