1,mysql -u root -p 登录mysql
2、grant all on *.* to sss@'%' identified by '123456' with grant option; sss为数据库名称,123456为相应的密码
3、flush privileges;
4、select host,user from mysql.user;
重启mysql
参考:
https://www.cnblogs.com/pqy521/p/7111268.html
https://jingyan.baidu.com/article/624e74597ff1bf34e9ba5a69.html