ALTER USER 'root'@'localhost' IDENTIFIED BY 'P@ssw0rd';
FLUSH PRIVILEGES;
6.重启mysql stystemctl restart mysqld 7.测试登录mysql 8.设置mysql允许任意ip远程root登录到服务器 GRANT ALL PRIVILEGES ON . TO 'root'@'%' IDENTIFIED BY 'P@ssw0rd' WITH GRANT OPTION; FLUSH PRIVILEGES; 9.Navicat测试远程登录mysql服务器