Shulou(Shulou.com)06/01 Report--

This article will explain in detail the method of allocating sub-accounts for phpmyadmin. The editor thinks it is very practical, so I share it with you for reference. I hope you can get something after reading this article.

How does phpmyadmin allocate sub-accounts? Phpmyadmin add ordinary user management account

Phpmyadmin is a mysql graphical management interface, we are here to introduce the addition of mysql users in phpmyadmin, I hope this article can bring help to all friends.

It is necessary for phpmyadmin to add non-root database management account security. Through phpmyadmin, you can easily add and delete users by mysql. After adding a non-root account, you can use the added account to log in to phpmyadmin to delete the original root account, which is good for security.

Step 1: open phpMyAdmin and click the "user" button in the menu bar to enter the user management page.

Step 2: the user management page lists the existing user information, and click "add user" to create a new user.

Step 3: enter the user name [User name]. There are two options: any user, use the text field, there is no obvious difference between them, it is recommended to select "use text field", and then enter the user name in the text box, such as sky.

Step 4: enter the host [Host] information. There are four options: any host (%), local (localhost), using the host table (host), and Use text field (even if the text field is used).

Any host means to match all hosts; local means local host only (localhost is entered by default); use host refers to the data in the host table in the MySQL database and does not need to fill in any information (this option is invalid if you do so); use text field to indicate that you enter the host address information yourself. Select the Local option here.

Step 5: enter the password and Re-type (confirm password). There are two options: no password and using text fields. Select "use text field" here, you can enter the password manually, or you can click the [generate] button to automatically generate the password and display it in the bottom text box.

Step 6: assign permissions to the user. Rights management is divided into two parts: user database and global permissions.

The user database includes two options: create a database with the same name as the user and grant all permissions; grant all permissions to the database with the user name _ enabled. You can choose according to your needs. Neither is selected here, only new users are created.

Global permissions include four parts: data, structure, management, and resource restrictions. You can choose according to your needs. Here I chose "Select all", which is equivalent to all permissions of root. Of course, you can also leave the management option unselected, so that the account only has read and write permissions and does not have the administrative authority of the entire mysql.

Step 7: after the permissions are assigned, click the * * execute * * button in the lower right corner to create a new user. The old version seems to have to go back to the home page of phpMyAdmin and reload the license. One option is to click Reload privileges.

This is the end of the method of allocating sub-accounts for phpmyadmin. I hope the above content can be of some help to you and learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.