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

The following is about the authorization of mysql user management, the creation of users, the deletion of users, the secret of the text is close to the topic. So, no more gossip, let's go straight to the following, I believe you will benefit from reading the article on authorization, creating and deleting users of mysql user management.

View a list of users

Select from host,user,password from mysql.user

View authorization

Show grants for root@localhost

Create user authorization

Grant all privileges on. To root@localhost identified by '123456'

Delete user

Delete from mysql.user user='root'

Delete from mysql.user where user='root' and ip='localhost'

Is there anything you don't understand about the authorization, creation and deletion of user-related content managed by the above mysql users? Or 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.