当前位置:Gxlcms > 数据库问题 > 远程连接MySQL提示“Host is not allowed to connected to this MySQL server”

远程连接MySQL提示“Host is not allowed to connected to this MySQL server”

时间:2021-07-01 10:21:17 帮助过:3人阅读

192.168.1.3 is not allowed to connect to this MySQL server

这个时候需要授权:

GRANT ALL PRIVILEGES ON *.* TO root@192.168.1.3 IDENTIFIED BY mypassword WITH GRANT OPTION;
flush privileges;

就可以了。

远程连接MySQL提示“Host is not allowed to connected to this MySQL server”

标签:connect   ide   mys   his   需要   span   word   grant   ted   

人气教程排行