香港ECS上的MySQL數據同步到數加MaxCompute
ECS管理,設置安全組,添加外網3306 IP訪問權限;
通過控製台進入大數據開發套件;
點擊數據集成->左側列表"數據源"頁麵->點擊右上交“
Q:大數據開發套件(數據集成)中連接不上ECS上的MySQL ,提示:測試連接失敗,測試數據源連通性失敗:連接數據庫失敗, 數據庫連接串:jdbc:mysql://47.90.89.23:3306/MySQL57-hk, 用戶名:root, 異常消息:Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
:
Q:大數據開發套件(數據集成)中連接不上ECS上的MySQL ,提示:測試連接失敗,測試數據源連通性失敗:連接數據庫失敗, 數據庫連接串:jdbc:mysql://47.90.89.23:3306/mysql, 用戶名:root, 異常消息:null, message from server: "Host '121.43.110.160' is not allowed to connect to this MySQL server"
詳細參照:https://kouss.com/aliyun-ecs-mysql-allow-navicat.html
最後更新:2017-06-06 22:01:48