Shulou(Shulou.com)05/31 Report--

This article is about how to use phpmyadmin to set mysql permissions. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

Step 1: log in to root users.

Step 2: create a new data table and select the collation, where I use testtable.

Step 3: let's create a new user and enter the relevant account name and password.

Step 4: let's edit the user testuser permissions that we just added:

After entering the page, we just need to choose to set permissions by database. Global permissions are not checked.

After clicking, a permission page will appear, and you can select all of them for execution.

At this point, all we see after logging in to the testuser is the testtable library and the relevant operation permissions of this table.

Thank you for reading! On "how to use phpmyadmin to set mysql permissions" this article is shared here, I hope the above content can be of some help to you, so that you can learn more knowledge, if you think the article is good, you can share it out for more people to see it!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.