How to use phpmyadmin to set mysql permissions

Step 1: Log in as root user

Step 2: Create a new database and select the sorting rules, here I use testtable

#Step 3: We create a new user and enter the relevant account name and password

Step 4: We edit the permissions for the user testuser we just added

After entering the page, we only need to choose to specify permissions by database. There is no need to check global permissions

After clicking, a permissions page will appear. Just select all and execute

At this time After we log in as testuser, we only see the testtable library and the related operation permissions of this table

Recommended related articles and tutorials: phpmyadmin tutorial

The above is the detailed content of How to use phpmyadmin to set mysql permissions. For more information, please follow other related articles on the PHP Chinese website!