mysql 开启远程连接

UPDATE USER SET HOST = '%' WHERE USER = 'root'; 

SELECT HOST, USER FROM USER; 

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root用户密码' WITH GRANT OPTION ;      

FLUSH PRIVILEGES ;