首页 > 代码库 > msyql无法远程登录

msyql无法远程登录

error1:

ERROR 1045 (28000): Access denied for user ‘root‘@‘xyt.local‘ (using password: YES)

grant all on mysql.* to root@192.168.11.172 identified by 1111

 

error2:

Host ‘ubuntu.local‘ is not allowed to connect to this MySQL server

GRANT ALL PRIVILEGES ON *.* TO root@%;FLUSH PRIVILEGES;