mysql -u root -pvmware
mysql>use mysql;
mysql>update user set host = '%' where user = 'root';
mysql>flush privileges;
mysql>select host, user from user;
相关文章
- MySQL5.5.51启用网络远程连接
- 为MySQL设置安全的远程连接
- Mysql远程连接报错:Host is not allowed to connect to this MySQL server
- Navicate远程连接数据库(linux Centos7) 报错 2003 cannot connect mysql on( 10060)
- MySQL 设置允许远程连接完整指南:安全与效率并重
- 设置Mysql数据库root账户允许远程连接
- windows环境下:MySQL远程连接失败(错误码:2003)
- Mysql-报错:1130-host ... is not allowed to connect to this MySql server 开放mysql远程连接 不使用localhost
- MySQL 开启远程连接
- 远程桌面连接MySQL遇到的问题及解决方法总结