远程连接数据库出错

远程安全组要打开3306端口,

本地创建用户的时候用的语句:

GRANT ALL PRIVILEGES ON *.* TO 'root'@'230.125.189.54' IDENTIFIED BY '123',

其中230.125.289.54位公网ip;

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'newpass' WITH GRANT OPTION; flush privileges;这是完成开权限远程的写法

原文地址:https://www.cnblogs.com/hoewang/p/10257271.html