blocks|key|2729163|text|尝试在XAMPP控制面板中重新启动MYSQL应用程序。对我起作用了。祝好运!|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2729164|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

try restarting the MYSQL app in the XAMPP control panel. It worked for me. Good luck!

blocks|key|125555|text|转到Start->Run并键入services.msc。这就是如何进入windows服务窗口的方法。查找MySQL服务器，右键单击，启动服务。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|125556|还可以通过启动->控件面板->管理工具->服务访问Windows窗口|125557|如果没有这样的服务MySQL服务器，那么从这里安装MySQL服务器https://dev.mysql.com/downloads/mysql/|offset|length|125558|entityMap|0|LINK|mutability|MUTABLE|url|https://dev.mysql.com/downloads/mysql/^0|0|0|X|12|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Q|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@$F|S|G|T|1|U]]|A|$]]|$1|H|3|-4|5|6|7|V|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|O]]]]

Go to Start->Run and type services.msc. That's how you get to windows services window. Look for MySQL Server, Right Click, Start Service.

You could also get to Windows Services Window by Start -> Control Panel -> Administrative Tools -> Services

If there's no such service MySQL Server, then install MySQL Server from here
<a href="https://dev.mysql.com/downloads/mysql/" rel="nofollow">https://dev.mysql.com/downloads/mysql/</a>

blocks|key|125566|text|解决办法很简单。问题是mysql服务没有启动。因此，我们首先需要在“mysql+-u+user_name+-p”命令之前启动mysql服务。为此，请在命令提示符中导航到mysql的“bin”文件夹。例如：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|125567|C:\Program+Files\MySQL\MySQL+Server+5.7\bin>|code-block|syntax|javascript|125568|在你的情况下，|125569|C:\Program+Files+(x86)\MySQL\MySQL+Workbench+CE+6.0.9\bin>|125570|或|125571|C:\Program+Files+(x86)\MySQL\bin>|125572|125573|如果已经安装了XAMPP，那么要启动与之关联的mysql，请导航到|125574|C:\xampp\mysql\bin>|125575|然后键入命令mysqld+-u+root+-p|offset|length|style|CODE|125576|它将输出：|125577|'2017-04-04+13:40:27+8536备注mysqld+(mysqld+10.1.21-MariaDB)开始处理5640+.‘|blockquote|125578|这显示mysql已经启动。|125579|现在输入您的命令mysql+-u+root+-p，它肯定会工作的。|125580|entityMap^0|0|0|0|0|0|0|0|0|0|6|H|0|0|0|0|8|G|0^^$0|@$1|2|3|4|5|6|7|1A|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|1B|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|1C|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|1D|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|1E|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|1F|8|@]|9|@]|A|$E|F]]|$1|O|3|L|5|6|7|1G|8|@]|9|@]|A|$]]|$1|P|3|Q|5|6|7|1H|8|@]|9|@]|A|$]]|$1|R|3|S|5|D|7|1I|8|@]|9|@]|A|$E|F]]|$1|T|3|U|5|6|7|1J|8|@$V|1K|W|1L|X|Y]]|9|@]|A|$]]|$1|Z|3|10|5|6|7|1M|8|@]|9|@]|A|$]]|$1|11|3|12|5|13|7|1N|8|@]|9|@]|A|$]]|$1|14|3|15|5|6|7|1O|8|@]|9|@]|A|$]]|$1|16|3|17|5|6|7|1P|8|@$V|1Q|W|1R|X|Y]]|9|@]|A|$]]|$1|18|3|-4|5|6|7|1S|8|@]|9|@]|A|$]]]|19|$]]

The solution is very simple. The problem is the mysql service is not started. So we first need to start the mysql service before 'mysql -u user_name -p' command.
To do that, navigate to 'bin' folder of mysql in command prompt.
E.g:

<pre><code>C:\Program Files\MySQL\MySQL Server 5.7\bin&gt;
</code></pre>

In your case probably,

<pre><code>C:\Program Files (x86)\MySQL\MySQL Workbench CE 6.0.9\bin&gt;
</code></pre>

or

<pre><code>C:\Program Files (x86)\MySQL\bin&gt;
</code></pre>

or

If you have XAMPP installed, then to start mysql associated with it, navigate to

<pre><code>C:\xampp\mysql\bin&gt;
</code></pre>

then type the command <code>mysqld -u root -p</code>

It will output: 

<blockquote>
 '2017-04-04 13:40:27 8536 [Note] mysqld (mysqld 10.1.21-MariaDB) starting as process 5640 ...'
</blockquote>

This shows mysql is started.

Now type your command <code>mysql -u root -p</code>, it will work for sure.

blocks|key|125601|text|打开Xampp控制面板并启动mysql模块。对于wamp来说，也是如此。这是我有过的最简单的解决方案！|type|unstyled|depth|inlineStyleRanges|entityRanges|data|125602|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Open the Xampp control panel and start the mysql module. For wamp, do the same.
 This is the simplest ever solution I've got !

blocks|key|125607|text|协议=TCP+-P3306+-u用户-p|type|unstyled|depth|inlineStyleRanges|entityRanges|data|125608|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

mysql --protocol=TCP -P3306 -u user -p

blocks|key|2729276|text|我遇到了同样的错误，我使用下面的命令在一个cmd窗口中作为管理员启动了MySQL服务器，然后尝试在另一个cmd窗口连接mysql，它成功了！|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2729277|cmd窗口1:+C:\Program+\MySQL\MySQL服务器8.0\bin>mysqld|2729278|cmd窗口2:+C:\Program+\+MySQL+\MySQL服务器8.0\bin>mysql+-u根-p输入密码：*欢迎来到MySQL监视器。命令以；或\g结尾。MySQL连接id为8服务器版本:+8.0.26|2729279|版权(c)+2000、2021、Oracle和/或其附属公司。|2729280|甲骨文是甲骨文公司和/或其附属公司的注册商标。其他名称可能是其各自所有者的商标。|2729281|键入“help；”或“\h”以表示帮助。键入'\c‘以清除当前输入语句。|2729282|mysql>|2729283|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Q|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|S|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|T|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|U|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|V|8|@]|9|@]|A|$]]|$1|N|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|O|$]]

I got the same error, I started MySQL server with the below command as an administrator in one cmd window and then tried connecting mysql in another cmd window, it worked !!
cmd window 1:
C:\Program Files\MySQL\MySQL Server 8.0\bin&gt;mysqld
cmd window 2:
C:\Program Files\MySQL\MySQL Server 8.0\bin&gt;mysql -u root -p
Enter password: ************
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.26
Copyright (c) 2000, 2021, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql&gt;

I'm following <a href="http://www.vogella.com/tutorials/MySQL/article.html" rel="nofollow">Vogella's tutorial on MySQL</a> and I'm hitting a brick wall when I try to imitate the example. I've installed MySQL, and as he instructs I run it from the command line. When I do so, I get this error:

<pre><code>C:\Program Files (x86)\MySQL\MySQL Workbench CE 6.0.9&gt;mysql -u root -p
Enter password: ******
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)

C:\Program Files (x86)\MySQL\MySQL Workbench CE 6.0.9&gt;
</code></pre>

Does anyone know why?

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

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我跟随，当我试图模仿这个例子时，我撞到了一块砖墙。我已经安装了MySQL，按照他的指示，我从命令行运行它。当我这样做时，我会得到以下错误：C:\Program Files (x86)\MySQL\MySQL Workbench CE 6.0.9>mysql -u root -pEnter password: *****...

问MySql错误错误2003 (HY000)：无法连接到'localhost‘上的MySQL服务器(10061)
EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问MySql错误错误2003 (HY000)：无法连接到'localhost‘上的MySQL服务器(10061)EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问MySql错误错误2003 (HY000)：无法连接到'localhost‘上的MySQL服务器(10061)
EN