phpMyAdmin Add ordinary user admin Account graphic Tutorial

phpMyAdmin adding non-root database management account security is still necessary. Through the phpMyAdmin can be convenient for MySQL add delete users and other operations. After adding a non-root account you can use the added account login phpMyAdmin Delete the original root account, for security is still good.

1th Step: Open phpMyAdmin, click on the menu bar "User" button, into the User Management page.

2nd Step: User Management page lists the existing user information, click "Add User" to create a new user.

3rd Step: Enter the username "user name". There are two options: Any user, use a text field, there is no significant difference between them, it is recommended to select "Use Text field", and then enter the user name in the text box, such as Sky.

4th step: Enter the host "host" information. There are four options: any host (%), local (localhost), use the host table (hosts), the Use text field (that is, using a text field).
Any host representation matches all hosts, local representation is local only (default fills in localhost); Use hosts to refer to data in the host table in the MySQL database, without filling in any information (if this option is not valid if you fill in); Use a text field to indicate that you are filling out the host address information. Here, select the local option.

5th step: Enter the password and re-type (Confirm password). There are two options: no password, use a text field. Select "Use text field" Here, you can enter the password manually, you can also click the "Build" button, automatically generate the password and in the bottom text box display.

Step 6th: Assign permissions to users. Rights Management is divided into two big chunks: User database and Global permissions.
The user database consists of two options: creating a database with the same name as the user and granting all permissions, and granting all permissions to a database opened by the user name. Can be selected on demand. No two are selected here, only new users are created.
Global permissions include four parts: data, structure, management, and resource constraints. Can be selected on demand. I chose "Select All" here, all the permissions equivalent to root. Of course, you can also manage that do not choose, so that the account only has read and write permissions and not the entire MySQL Management authority.

7th: After the right allocation, click on the lower right-hand corner of the "Execute" button, to create a new user action. The old version seems to return to phpMyAdmin's homepage, reload authorization, there is an option is reload privileges click on the