Shulou(Shulou.com)06/01 Report--

Yesterday bought a year's Ali cloud server, the system is linux Centos7, full of longing to install a mysql, the following day let me almost doubt life.

I won't say much about how to install mysql. Anyway, I installed it three times, and every time I can connect to the database locally on Aliyun.

You can't connect to Aliyun's database remotely with navcat. Always report: 2003-Can't connect to MySQL SERVER ON * (10060)

After installing it three times, you will know how desperate I am, because the first time I installed mysql under linux, I thought there might be something wrong with the installation.

Baidu has been torn up by me.

What firewall, what authorization, installed three times, I tried three times, all failed

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

Enter Ali Cloud Management and Control backend-CVM ECS---- security group

There is a "configuration rule" on the right. Click on it to enter the configuration page.

All right, add a security group here, configure the port number of mysql, and match it as you like.

Now you can connect to the database remotely using navcat.

As for how I thought the problem was in Aliyun, it was because I had installed it three times and began to doubt life, and suddenly I thought, I installed tomcat first, and after it was started at that time, the test report reported 404. I had installed tomcat many times before, and I could be sure that it had no problem. Later, Baidu targeted Baidu was equipped with port 8080 here at that time, and tomcat could be accessed, and then mysql came here to try. It turned out to be.

It took a day, Ali, to give me back my time. My time. Time. Yin.

The above is the whole content of this article, I hope it will be helpful to your study, and I also hope that you will support it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.