Shulou(Shulou.com)06/01 Report--

This article will explain in detail how to use phpmyadmin to set mysql permissions. The editor thinks it is very practical, so I share it for you as a reference. I hope you can get something after reading this article.

Step 1: log in to the root user

Step 2: create a new database and select the collation, where I use testtable

Step 3: we can 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 specify permissions by database. Global permissions need not be checked

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

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

On how to use phpmyadmin to set mysql permissions to share here, I hope that the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

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.