解决mysql 客户端连接问题
时间:2021-07-01 10:21:17
帮助过:2人阅读
解决方法1:
1.登录mysql: mysql -uroot -proot
2.授权:GRANT ALL PRIVILEGES ON *.* TO ‘myuser‘@‘%‘ IDENTIFIED BY ‘mypassword‘ WITH GRANT OPTION;
3.刷新权限:FLUSH PRIVILEGES;
4.退出:EXIT
解决方法2:
1. 登录mysql: mysql -uroot -proot
2. 选择mysql数据库:use mysql;
3. 修改访问权限:update user set host = ‘%‘ where user = ‘root‘;
4. 刷新权限:FLUSH PRIVILEGES;
5. 退出:EXIT
解决mysql 客户端连接问题
标签: