Use phpmyadmin to set mysql permissions.

Use phpmyadmin to set mysql permissions.

Step 1: log on to the root user.

Step 2: Create a new data table and select a sorting rule. Here we use testtable.

Step 3: Create a new user and enter the relevant account name and password.

Step 4: edit the added user testuser:

After entering the page, we only need to choose to set permissions by database. Do not select global permissions.

After you click it, a permission page is displayed. Select all permissions for execution.

After logging on to testuser, we only see the testtable database and related operation permissions for this table.

Summary

The above section describes how to use phpmyadmin to set mysql permissions. I hope it will be helpful to you. If you have any questions, please leave a message and I will reply to you in a timely manner. Thank you very much for your support for the help House website!