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

How to create a super user in mysql? I believe many inexperienced people don't know what to do about it. Therefore, this article summarizes the causes and solutions of the problem. Through this article, I hope you can solve this problem.

First log in to MySql with the ROOT user on the local database, and then:

Mysql > GRANT ALL PRIVILEGES ON *. * TO

[email=admin@localhost] admin@ localhost[ / email]

IDENTIFIED BY 'something' WITH GRANT OPTION

Mysql > GRANT ALL PRIVILEGES ON *. * TO

[email=admin@ "%] admin@"% [/ email]

"IDENTIFIED BY 'something' WITH GRANT OPTION

The first sentence adds an admin user authorized to access through the local machine (localhost) with the password "something". The second sentence is to grant admin users access from any other host (wildcard%).

After reading the above, have you mastered how to create a superuser in mysql? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for reading!

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.