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.

View comments