How to set the permissions of mysql database user with phpmyadmin_PHP tutorial

1. First, you need to install and configure phpMyAdmin on the server

For details on the installation and configuration method: http://www.jb51.net/article/15330.htm

After installation, come to The homepage of phpMyAdmin is as shown below:


2. Create a user (if you have already created a user before, you can skip this step)
Click on the image above After obtaining the permissions shown, you can see the following picture:

Click the "Add New User" link and add a new database user name
as shown in the following picture:

3. Permission settings
As shown in the figure below:

Edit the permissions of the user hellen
As shown in the figure below:

You can also fill in the user's permissions when adding a user, or you can edit the user's permissions after adding the user
These permissions are described in detail below:
1. Data part
SELECT: Allows reading data
INSERT: Allows inserting and replacing data
UPDATE: Allows changing data
DELETE: Allows deletion of data
FILE: Allows Import data from data, and allow exporting data to files

2. Structure part
CTEATE: allows the creation of new databases and tables
ALTER: allows modification of the structure of existing tables
INDEX: Allows creation and drop 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 query attempts
CREATE ROUTINE: Allows creation of new stored procedures
ALTER ROUTINE: Allows modification of stored procedures
EXECUTE: Allows execution of queries
Management and resource restrictions are not explained in detail here. Generally, all administrators have root accounts. Permissions, the above mentioned are ordinary user permissions.

4. Reload the authorization form
After modifying the user permissions, you need to return to the homepage of phpMyAdmin and reload the authorization
As shown in the figure below:

As long as you understand the user permission settings, I believe you will be able to manage the database with ease.

http://www.bkjia.com/PHPjc/324780.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/324780.htmlTechArticle1. First, you need to install and configure phpMyAdmin on the server. For details on the installation and configuration method, see: http://www.jb51 .net/article/15330.htm After installation, go to the homepage of phpMyAdmin as shown below...