使用Navicat远程阿里云服务器上MySQL

一、首先要mysql授权

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

二、Navicat远程连接阿里云ECS数据库

使用Navicat通过SSH在本地连接远程数据库