If there are too many people accessing and managing a database system, then not every user needs to access all databases or tables. At this time, we need to grant permissions to various roles. set up.
If we add a user test, and we only want him to be able to access a specific test table, but not other tables, then we can do this:
1. Log in using the root user phpmyadmin
2. Click the "User" link on the navigation bar
3. Click the "Add User" link
4. Fill in the new user name in the user name column, fill in the user password in the password and re-enter columns respectively, select
in the "Host" column according to the user's situation, and then directly click "Execute" at the bottom right of the page link, so that the new user is added
For more phpmyadmin related technical articles, please visit the phpmyadmin tutorial column!
The above is the detailed content of How to add users in phpmyadmin. For more information, please follow other related articles on the PHP Chinese website!