Get the App
SLTechnology News&Howtos  ›  Development  › 

How to solve the problem of ERROR 2003 (HY000): Can't connect to MySQL server on & # 039; (10061)

Shulou Source: shulou.com Published: 2022-06-03 05:32:49 10月03日 Update

This article mainly explains "how to solve the ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061) problem". The content of the article is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn "how to solve the ERROR 2003 (HY000): Can't connect to MySQL server on' localhost' (10061) problem".

Recently, I suddenly found that my mysql connection database appeared.

ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)

That is, the MySQL service on the local computer starts and stops. Some services stop automatically when they are not used by other services or programs

Then I found a lot of methods on the Internet: some said to restart the computer, some said to find the bin address of mysql, and then how to delete data content, but it didn't work, and finally found a very good way.

Solution: the first step is to enter the bin directory of mysql as administrator cd:

Cd C:\ Program Files\ MySQL\ MySQL Server 5.5\ bin

Enter:

Mysqld-skip-grant-tables

Open a new cmd as an administrator, and then enter the bin directory:

Cd C:\ Program Files\ MySQL\ MySQL Server 5.5\ bin

Enter:

Mysql-uroot

The problem has to be solved:

Conclusion: there are so many situations can not solve the solution, and finally found that there may be too many connected databases? Change passwords frequently? I don't know.

But the benefit is that when we can't find a solution, we might as well search in another word, for example, I initially searched ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061).

I didn't find the results I wanted, and then I found the answer: mysql has been connected normally, and then there is ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061).

Thank you for your reading. The above is the content of "how to solve the ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061) problem". After the study of this article, I believe you have a deeper understanding of how to solve the ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061) problem, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Tags: Problem content method learning service situation data database scheme directory administrator identity search management input no frequent unknown benefit a lot in a word Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno NVidia Shulou Tech Info macOS Linux Huawei