使用Navicat Premium 12遠端連接配接阿裡雲MySQL8.0

1.先登陸mysql:

mysql -u root -p

2.再輸入：

grant all privileges on *.* to 'root'@'%' identified by 'yourPassword';#填密碼

3.然後就報了這個錯：

ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement

解決辦法;

mysql> flush privileges;

Query OK, 0 rows affected (0.01 sec)

mysql> grant all privileges on *.* to 'root'@'%' identified by 'yourPassword';#填密碼

Query OK, 0 rows affected (0.00 sec)

4.然後用Navicat Premium 12遠端連接配接阿裡雲MySQL8.0

如果連接配接失敗的話，應該是沒有在阿裡雲背景系統管理中，添加安全組

填寫安全規則時，協定類型選了mysql3306後端口自動填寫，授權對象填寫0.0.0.0/0即可

參考資料：

https://www.cnblogs.com/iosdev/archive/2013/07/15/3190431.html

https://blog.csdn.net/qq_40930491/article/details/87270926