Solution to MySQL connection exception and error 10061

MySQL is a relational database management system developed by Swedish company MySQL AB and currently a product of Oracle. MySQL is one of the most popular relational database management systems (RDBMS).

When trying to start the MySQL server, the error message "Can't connect to MySQL server on '127.0.0.1' (10061) (2003)" appears, and the MySQL server fails to start.

Solution: Start->services.msc (Open Services)->Find MySQL in the service list->Right-click MySQL and click Start

However, sometimes MySQL is clearly installed, but there is no MySQL in the service list. What should I do?

Solution:

1. Open cmd (run C:\Windows\System32\cmd.exe as administrator),
2. Use the cd command to switch the directory to the bin directory of MySQL Server 5.6, the MySQL installation directory;
3. Execute the following command: C:\Program Files\MySQL\MySQL Server 5.6\bin>mysqld.exe -install
4. When Service successfully installed appears, it means that the MySQL service is installed successfully.

At this time, the MySQL service has appeared in the computer service.

Of course, you can directly execute the following command in the above directory: C:\Program Files\MySQL\MySQL Server 5.6\bin>net start mysql. When the prompt that the MySQL service has been started successfully appears, it indicates that the connection to MySQL is successful.

This is the end of this article about how to solve the MySQL connection exception 10061 error problem. For more information about the MySQL connection exception 10061 error, please search for previous articles on 123WORDPRESS.COM or continue to browse the following related articles. I hope you will support 123WORDPRESS.COM in the future!