Home > Database > Mysql Tutorial > body text

How to solve mysql error 2005 problem

藏色散人
Release: 2022-01-14 09:05:05
Original
10778 people have browsed it

Solution to mysql error 2005: 1. Turn off data operation; 2. Open Navicat premium; 3. Modify the connection address and save it.

How to solve mysql error 2005 problem

The operating environment of this article: Windows 7 system, mysql version 5.6.26, Dell G3 computer.

How to solve the mysql error 2005 problem?

This problem suddenly occurred before today’s defense. Baidu tried many methods, but I don’t know which one worked.

A 2005 error occurs when connecting to Navicat Premium. The error code means that the host localhost cannot be connected.


The following problem occurs when starting the server from cmd

How to solve mysql error 2005 problem

1. Close data operation

E:\mysql\mysql-5.6.26-winx64\bin>mysqladmin -u root -p shutdown
Copy after login

2. E:\mysql\mysql-5.6.26-winx64\bin>mysql-uroot -p –hlocalhost


##After this I will I can connect to the mysql database from the system I built, but Navicat Premium still reports an error

Then my classmate told me

After modifying the connection address, Navicat Premium can connect normally

How to solve mysql error 2005 problem

Recommended study: "

mysql video tutorial"

The above is the detailed content of How to solve mysql error 2005 problem. For more information, please follow other related articles on the PHP Chinese website!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!