一、非云服务主机
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '你的密码' WITH GRANT OPTION;
FLUSH PRIVILEGES;
二、云服务主机
update user set host='%' where user='root' and host='localhost';
FLUSH PRIVILEGES;
一、非云服务主机
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '你的密码' WITH GRANT OPTION;
FLUSH PRIVILEGES;
二、云服务主机
update user set host='%' where user='root' and host='localhost';
FLUSH PRIVILEGES;