远程安全组要打开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;这是完成开权限远程的写法
远程安全组要打开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;这是完成开权限远程的写法