1. Open the local Navicat, click Connection--New Connection--MySQL, the following picture will appear:
Connection name: fill in any
Host: Alibaba Cloud's IP address
Password: The password configured when installing MySQL.
Then, click "OK".
Related recommendations: "Navicat for mysql graphic tutorial"
2. At this time, click on the newly created "Alibaba Cloud" link. There was an error in mine (but I forgot to take a screenshot)
3. Set the port range, and set the port range 3306 here.
#4. Then log in to the Alibaba Cloud server, open the MySQL 5.6 control panel, and enter the password. Change the host's defense scope by changing the table.
Run to the interface below:
mysql>use MySQL mysql> update user set host='%' where user='root'; mysql>select host,user from user;
4. It’s time to configure, double-click the “Alibaba Cloud” connection. If the error as shown below still occurs, then perform the fifth step and restart the MySQL database on the Alibaba Cloud server.
#5. Then restart MySQL, click the win icon - enter "Service" - double-click "Service".
Then find and restart the MySQL service.
#6. The error that appeared above will disappear. Double-click the "Alibaba Cloud" link created in Navicat. The connection is successful.
The above is the detailed content of How to connect Alibaba Cloud server to navicat. For more information, please follow other related articles on the PHP Chinese website!
