linux服务器远程连接mysql

总阅读量次

1、登录数据库mysql

[root@Centos ~]# mysql -uroot
mysql> update user set password=password('123456') where user='root' and host='localhost'; 
mysql> flush privileges;

2、设置远程登录

mysql> GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY '123456' WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

3、远程Navicat(或者其他mysql管理工具)访问云服务器的数据库

赏

谢谢你请我吃糖果

支付宝

微信