Shulou(Shulou.com)05/31 Report--

Editor to share with you how Navicat solves the problem of connecting MySQL Times 10060, 1045 errors and my.ini location. I believe most people don't know much about it, so share this article for your reference. I hope you will get a lot after reading this article. Let's learn about it together.

10060 and 1045 errors of Navicat connection database. Where is the my.ini file of MySQL8.0.18?

The reason for this is that port 3306 is banned by the firewall and cannot connect to the port. First, Win+R, run services.msc to see if the MySQL service is turned on

I see that the MySQL80 network service is not running. When I want to open it...

Unable to start the service

Solution (create port 3306)

1. Control Panel-> Windows Defender Firewall-> Advanced Settings-> inbound rules

Check to see if 3306 port number is enabled

Because my 3306 port number is disabled, I don't have it here.

two。 Inbound rules-> New rules-> Port-> TCP specific Local Port-> enter 3306-> allow connection-> hook all-> then name yourself

3. Set Port

4. When I thought I wanted to solve the 10060 error report, I tried to use Navicat and the command line to enter the database, and there was a 1045 error report.

And then I found a service.

I found that MySQL80 still could not be started, and then I clicked on the properties of the MySQL and MySQL80 services:

Their executable paths don't seem to be the same, and when I saw the executable path of MySQL80, I was surprised to find:

The my.ini file for MySQL8.0.18 is not in the installation directory of MySQL (D:\ Program Files\ MySQL\ MySQL Server 8.0), but in the directory shown (D:\ ProgramData\ MySQL\ MySQL Server 8.0\ my.ini)

5. Later, I turned off the MySQL service (set it to be turned on manually) and found that I could start the MySQL80 service.

6. It will be fine when you connect to the database with Navicat.

The above is all the content of this article entitled "how Navicat solves the problem of connecting MySQL Times 10060, 1045 errors and my.ini location". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

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.