mysql被禁止远程登录了,所以需要设定特定ip地址具有登录mysql权限。
GRANT ALL PRIVILEGES ON *.* TO 'root'@'123.123.123.123' IDENTIFIED BY 'yourMysqlPassword' WITH GRANT OPTION;
flush privileges;
注意上面那句必须大写,反正我用小写进行授权,是不成功的。
mysql被禁止远程登录了,所以需要设定特定ip地址具有登录mysql权限。
GRANT ALL PRIVILEGES ON *.* TO 'root'@'123.123.123.123' IDENTIFIED BY 'yourMysqlPassword' WITH GRANT OPTION;
flush privileges;
注意上面那句必须大写,反正我用小写进行授权,是不成功的。