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

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

This error is often encountered by novices. This article mainly introduces how to fix ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
Solution:
1. Log in to the host where MySQL is installed, open the cmd command line tool, execute the command mysql -uroot -p, and the error described below will be reported;

insert image description here

2. Find Computer Management in the Start menu, find [Services] in Computer Management, and check whether there is a MySQL service in the service;

insert image description here

insert image description here

3. If the MySQL service cannot be found in [Step 2], you need to manually install the MySQL service. The installation command is mysqld -install. Since the MySQL service has been installed on this machine, the following prompt will appear: The service already exists!

insert image description here

4. If the Mysql service can be found in [Step 2], double-click the service to view the current status of the service. If it is not running, click [Start] to run the service;

insert image description here

5. In addition, you can also start the Mysql service by executing the command net start mysql in cmd;

insert image description here

6. After the Mysql service is successfully started, execute the command in [Step 1] again to connect to the Mysql database normally.

insert image description here

This is the end of this article about solving the MySQL startup error: ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061). For more information about MySQL error: ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061), please search 123WORDPRESS.COM's previous articles or continue browsing the following related articles. I hope you will support 123WORDPRESS.COM in the future!

You may also be interested in:
  • MySQL bypasses granting information_schema objects and reports ERROR 1044 (4200) error
  • mysql databasemysql: [ERROR] unknown option ''--skip-grant-tables''
  • How to solve the 10060 unknow error when Navicat remotely connects to MySQL
  • Ubuntu 18.0.4 installs mysql and solves ERROR 1698 (28000): Access denied for user ''''root''''@''''localhost'''
  • ERROR 2002 (HY000): Can't connect to local MySQL server through socket ''/tmp/mysql.sock''
  • Solution to MySQL server login error ERROR 1820 (HY000)

<<:  Detailed explanation of jQuery's copy object

>>:  Troubleshooting the cause of 502 bad gateway error on nginx server

Blog    

Recommend

Vue sample code for implementing two-column horizontal timeline

Table of contents 1. Implement the component time...

CentOS 7 cannot access the Internet after modifying the network card

Ping www.baidu.com unknown domain name Modify the...

How to start a transaction in MySQL

Preface This article mainly introduces how to sta...

Vue2.x responsiveness simple explanation and examples

1. Review Vue responsive usage​ Vue responsivenes...

Front-end AI cutting tips (experience)

AI image cutting needs to be coordinated with PS....

svg+css or js to create tick animation effect

Previously, my boss asked me to make a program th...

Completely uninstall MySQL database in Windows system to reinstall MySQL

1. In the control panel, uninstall all components...

Building a KVM virtualization platform on CentOS7 (three ways)

KVM stands for Kernel-based Virtual Machine, whic...

Summary of MySQL basic common commands

Table of contents MySQL basic common commands 1. ...

border-radius method to add rounded borders to elements

border-radius:10px; /* All corners are rounded wi...

Advantages of MySQL covering indexes

A common suggestion is to create indexes for WHER...