How to use phpmyadmin to set the permissions of the mysql database user

found that many users do not understand the database user permissions settings, the following for everyone to explain how to use phpMyAdmin to set the permissions of the database user First, you need to install and configure phpMyAdmin on the server See the installation and configuration method for details: http://www.45it.com/net/201209/32566.htm After installation, go to the phpMyAdmin home page as shown below: Second, create a user (how you have created a user before, You can omit this step. After clicking the permission shown in the above figure, you can see the following picture: Click “Add new user” This connection, add a new database user name as shown below: Third, the permission settings are as follows The figure shows: Edit the permissions of the user of hellen as shown in the following figure: The user can also fill in the user's permission at the same time, or add the user's permission after editing the user. The following describes these permissions in detail: The data part SELECT: refers to the data that is allowed to read INSERT: refers to the permission to insert And replacement data UPDATE: refers to the change of data DELETE: refers to the permission to delete data FILE: refers to the import of data from the data, and allows the data to be exported to the file 2, the structural part CTEATE: allow the creation of a new database and table ALTER: Allows modification of the structure of existing tables INDEX: Allows creation and deletion of indexes DROP: Allows deletion of databases and tables CREATE TEMPORARY TABLES: Allows creation of temporary tables CREATE VIEW: Allows creation of new views SHOW VIEW: Allows queries to attempt CREATE ROUTINE: Allows creation of new ones Stored procedure ALTER ROUTINE: Allows to modify the stored procedure EXECUTE: Allows to perform query management and resource restrictions. It is not described in detail here. Generally, the administrator root account has all the permissions. The above is the normal user rights. Fourth, reload the authorization table After modifying the user rights, you need to go back to the phpMyAdmin home page, reload the authorization as shown below: As long as you understand the user's permission settings, I believe that your management of the database will be handy.