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

This article is mainly about how Mysql sets permissions for users. If you are interested, let's take a look at this article. I believe it is of some reference value to you after reading how Mysql sets permissions for users.

# configure read-only users. All indicates all permissions

GRANT SELECT ON miao_mu_data.* TO 'username' @% 'IDENTIFIED by "password"

# View user permissions

Use mysql

Select * from user

Does the above details about how Mysql set permissions to users help you? If you want to know more about it, you can continue to follow our industry information section.

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.