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

Recommend

Tips on HTML formatting and long files for web design

<br />Related articles: 9 practical suggesti...

Why web page encoding uses utf-8 instead of gbk or gb2312?

If you have a choice, you should use UTF-8 In fac...

Detailed graphic tutorial on how to enable remote secure access with Docker

1. Edit the docker.service file vi /usr/lib/syste...

Nginx dynamically forwards to upstream according to the path in the URL

In Nginx, there are some advanced scenarios where...

How to implement page jump in Vue project

Table of contents 1. Create a vue-cli default pro...

Apache Log4j2 reports a nuclear-level vulnerability and a quick fix

Apache Log4j2 reported a nuclear-level vulnerabil...

Detailed explanation of grep and egrep commands in Linux

rep / egrep Syntax: grep [-cinvABC] 'word'...

JavaScript to implement login form

This article example shares the specific code of ...

MySQL encoding utf8 and utf8mb4 utf8mb4_unicode_ci and utf8mb4_general_ci

Reference: MySQL character set summary utf8mb4 ha...

Nginx 502 Bad Gateway Error Causes and Solutions

I have encountered the Nginx 502 Bad Gateway erro...

Example code for implementing the "plus sign" effect with CSS

To achieve the plus sign effect shown below: To a...

IE conditional comments for XHTML

<br />Conditional comments are a feature uni...

Detailed explanation of the use of CSS pointer-events attribute

In front-end development, we are in direct contac...