A method to add new users and databases to a mysql database using PHPMYADMIN
- 2020-03-31 20:32:41
- OfStack
1. New database:
After entering the phpmyadmin admin interface, find the following text "create a new database", and then fill in the name of the database you want to create at the bottom. 2. Create a new account for this database
In phpmyadmin management interface, click on the "permissions", open the link, click on "add a new user", in the open pages will see "login information", enter the user name, host (typically local: localhost), password, because we now is for a single user to configure a single database permissions, so here we don't choose "global permission", then click "perform" button on the bottom of the then built a user name. 3. Add the database permissions for the newly created user
After add user, the upper part of the management interface will be prompted to "you have to add a new user", we can add permissions to the new users, now found in the following "to" authority specified by the database, and then click "add permissions in the following database" behind drop-down list, select the database, select all data below, then select structure except the bottom three check boxes, other all don't choose, then click "perform" button, this is configured the user fully manage this database permissions. Note:
1. Because we only want to give the user all the permissions to manage this database, but we do not have the administrative permissions of other databases, so we must pay attention when configuring the permissions.
2. INFORMATION_SCHEMA is an information database that holds information about all other databases maintained by the MySQL server. $CFG ['Servers'][$I]['hide_db'] = 'information_schema'; $CFG ['Servers'][$I]['hide_db'] =' information_schema'; In addition, if you select the "grant all privileges to username\_%" option in the "user database" when creating a new user, the new user can create a database that starts with "username_". < img Alt = "" border = 0 height = 821 SRC =" http://images.cnblogs.com/cnblogs_com/tdalcn/phpmyadmin-user-privileges.jpg "width = 1052 border = 0 >
Originally this site has this article, but because the text description of this content is more detailed than the original, so the two articles combined to see, more effective.
(link: #)
After entering the phpmyadmin admin interface, find the following text "create a new database", and then fill in the name of the database you want to create at the bottom. 2. Create a new account for this database
In phpmyadmin management interface, click on the "permissions", open the link, click on "add a new user", in the open pages will see "login information", enter the user name, host (typically local: localhost), password, because we now is for a single user to configure a single database permissions, so here we don't choose "global permission", then click "perform" button on the bottom of the then built a user name. 3. Add the database permissions for the newly created user
After add user, the upper part of the management interface will be prompted to "you have to add a new user", we can add permissions to the new users, now found in the following "to" authority specified by the database, and then click "add permissions in the following database" behind drop-down list, select the database, select all data below, then select structure except the bottom three check boxes, other all don't choose, then click "perform" button, this is configured the user fully manage this database permissions. Note:
1. Because we only want to give the user all the permissions to manage this database, but we do not have the administrative permissions of other databases, so we must pay attention when configuring the permissions.
2. INFORMATION_SCHEMA is an information database that holds information about all other databases maintained by the MySQL server. $CFG ['Servers'][$I]['hide_db'] = 'information_schema'; $CFG ['Servers'][$I]['hide_db'] =' information_schema'; In addition, if you select the "grant all privileges to username\_%" option in the "user database" when creating a new user, the new user can create a database that starts with "username_". < img Alt = "" border = 0 height = 821 SRC =" http://images.cnblogs.com/cnblogs_com/tdalcn/phpmyadmin-user-privileges.jpg "width = 1052 border = 0 >
Originally this site has this article, but because the text description of this content is more detailed than the original, so the two articles combined to see, more effective.
(link: #)