报错如图:
服务器上登录MySQL之后:
mysql> use mysql;
设置对外开放ip,让windows的Navicat可以连接上来,然后刷新,注意,记得开放云服务器端口,在云的安全组里面
mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> update user set host = '%' where user = 'root';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
© 版权声明
文章版权归作者所有,未经允许请勿转载。
相关文章
暂无评论...