✅ 操作成功!

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

发布时间:2023-06-17 作者:admin 来源:文学

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

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

 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;`

 

👁️ 阅读量:0