Alibaba Cloud ECS cloud server (linux system) cannot connect remotely after installing MySQL (pitfall)

Yesterday I bought an Alibaba Cloud server that has been in use for a year. The system is Linux Centos7. I installed MySQL with great anticipation, but the following day almost made me doubt my life. . .

I won’t go into details about how to install MySQL. Anyway, I installed it three times and was able to connect to the database locally on Alibaba Cloud every time.

I can't connect to Alibaba Cloud's database remotely using navcat. Always report: 2003 - Can't connect to MySQL SERVER ON ********* (10060)

After installing it three times, you will know how desperate I am. This is the first time I installed MySQL under Linux. Every time I thought there might be something wrong with the installation.

I have searched Baidu thoroughly. . . .

What firewall, what authorization, I installed it three times, I tried it three times, none of them worked

If you have installed it three times and tried it three times, if you have tried everything you should try, if you start to doubt your life, and if you happen to be an Alibaba Cloud server, then congratulations, here is the answer you want.

Enter Alibaba Cloud Management and Control Backend ---- Cloud Server ECS ---- Security Group

There is a "Configuration Rules" on the right, click it to enter the configuration page.

OK, add a security group here, configure the port number of mysql, and match it according to the example.

Now you can connect to the database remotely using navcat.

As for how I thought the problem was with Alibaba Cloud, it was because I had installed it three times and had begun to doubt my life. Suddenly, I remembered that I had installed Tomcat first, and after starting it, the test reported 404. I had installed Tomcat many times before, so I was sure that there was no problem with the installation. Later, I searched Baidu specifically, and found that port 8080 was configured here, so Tomcat could be accessed. Then I tried MySQL here, and it worked.

It took a day, Ali, give me back my time. . . My time. . . time. . . Negative. . . . . . .

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.