解决MySQL Access denied for user 'root'@'IP地址' 问题

1、mysql -u root -p 登陆进MYSQL;

2、执行以下命令:

GRANT ALL PRIVILEGES ON *.* TO 'your name'@'%' IDENTIFIED BY 'your password' WITH GRANT OPTION;
FLUSH PRIVILEGES;

3、exit;

posted @ 2019-04-16 23:01  lurkerzhang  阅读(196)  评论(0编辑  收藏  举报