mysql建立超级用户

//登录MYSQL
@>mysql -u root -p
@>密码
//创建用户
create user 'user'@'%' identified by '***********';

//刷新

flush  privileges ;

//授予所有权限

GRANT ALL PRIVILEGES ON *.* TO 'user'@'%' IDENTIFIED BY '******' WITH GRANT OPTION;

//刷新

flush  privileges ;
 

 

 

 

参考

https://www.cnblogs.com/penciler/p/4813157.html

 

https://www.cnblogs.com/janken/p/5500320.html

https://blog.youkuaiyun.com/shienquan/article/details/45024413