mysql 远程登入：host:192.168.0.12 is not allowed to connect mysql

mysql被禁止远程登录了，所以需要设定特定ip地址具有登录mysql权限。

GRANT ALL PRIVILEGES ON *.* TO 'root'@'123.123.123.123' IDENTIFIED BY 'yourMysqlPassword' WITH GRANT OPTION;

flush privileges;

注意上面那句必须大写，反正我用小写进行授权，是不成功的。