远程连接mysql报错1130，is not allowed to connect to...

默认mysql不允许远程连接，需要使用授权命令进行授权

GRANT ALL PRIVILEGES ON *.* TO '用户名'@'远端机器名或ip' IDENTIFIED BY '密码' WITH GRANT OPTION;

例：需要使用guest帐号从ip为192.168.1.5的电脑上使用“123456”密码远程到test数据库

GRANT ALL PRIVILEGES ON test.* TO 'guest'@'192.168.1.5' IDENTIFIED BY '123456' WITH GRANT OPTION;

在任何主机上使用root密码“123456”连接所有数据库

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;FLUSH PRIVILEGES;--设置生效