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

Today, I want to remotely connect to the MySQL on my server. The software I use is Navicat, and the MySQL version on the server is 5.7.

There was an accident the first time I connected

It probably means that the MySQL service cannot be connected, and the solution steps are as follows

First: first, check whether your Ali or Tencent server console opens port 3306 access. As to where to look, please help yourself to Baidu. As shown below, you can see that remote connection is not allowed.

If it's not open like me, then open it.

After all connections are enabled, try again

Another mistake. This time it probably means denying access to the MySQL service. The solution is as follows.

First: enter MySQL, select MySQL database, and view user=root information.

As you can see, users of root only allow local access. Now you need to change it to all or specify IP.

Mine is changed to all, do not forget to refresh flush privileges is to refresh permissions, and finally try to connect remotely

As you can see, you can connect remotely.

Summary: the first step is to check whether Ali or Tencent server backend is enabled to allow connection to port 3306.

The second part checks whether the root user of the MySQL table in the MySQL database allows remote connections.

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.