MYSQL开放远程登录权限

一、非云服务主机

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;