Navicat Access denied for 'password'. Authentication that can continue: publ1045 - Access denied for user 'root'@'139-218-163-195.sta.dodo.au' (using password: YES)

 

 用户名和密码正确，但是却没有在其他ip地址上访问的权限。需要登录MySQL然后修改ip访问权限。

`
GRANT ALL PRIVILEGES ON *.* TO '登录用户名（如：root）'@'%' IDENTIFIED BY '登录密码（如：123456）' WITH GRANT OPTION;
`
`
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
`
//刷新
`FLUSH PRIVILEGES;`

 

更多推荐

Navicat Access denied for ‘password‘. Authentication that can continue: publ1045