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;
解决MySQL Access denied for user 'root'@'IP地址' 问题
原文:https://www.cnblogs.com/lurkerzhang/p/10720756.html