ERROR 1045 (28000): Access denied for user ‘root‘@‘172.17.0.1‘ (using password: YES)
mysql 报错信息ERROR 1045 (28000): Access denied for user 'root'@'172.17.0.1' (using password: YES)可能的情况：不允许远程连接密码错误解决方法：授予远程访问权限GRANT ALL PRIVILEGES ON *.* TO root@'%' IDENTIFIED BY 'Grand_p0ss' WITH GRAN
·
mysql 报错信息
ERROR 1045 (28000): Access denied for user 'root'@'172.17.0.1' (using password: YES)
可能的情况：
- 不允许远程连接
- 密码错误
解决方法：
授予远程访问权限
GRANT ALL PRIVILEGES ON *.* TO root@'%' IDENTIFIED BY 'Grand_p0ss' WITH GRANT OPTION;
FLUSH PRIVILEGES;
修改密码：
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
无需安装部署，在线快速体验 Byzer
更多推荐
2
0- 0
已为社区贡献1条内容
所有评论(0)