Mysql 设置外部访问

mysql> use mysql;  
mysql> GRANT ALL ON *.* TO user@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;  

mysql -h172.21.5.29 -uuser -p123456  即可了

配合SQLyog的数据库复制功能

 

 

 

原文链接

 

https://www.linuxidc.com/Linux/2017-04/143203.htm