blocks|key|2349492|text|1)使用以下命令停止mysql+demon进程：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2349493|sudo+/etc/init.d/mysql+stop|code-block|syntax|javascript|2349494|2)使用|2349495|sudo+/usr/sbin/mysqld+--skip-grant-tables+--skip-networking+&|2349496|因为此时您没有检查用户隐私，所以禁用网络是最安全的。在达珀，/usr/bin/mysqld..。不起作用。然而，mysqld+--跳过--授权--桌子做到了。|blockquote|2349497|1)使用以下命令启动mysql客户端进程|2349498|mysql+-u+root|2349499|2)从mysql提示符中执行以下命令，以便能够更改任何密码|2349500|FLUSH+PRIVILEGES;|2349501|3)然后重置/更新你的密码|2349502|SET+PASSWORD+FOR+root@'localhost'+=+PASSWORD('password');|2349503|4)如果您有一个可以从任何地方连接的mysql根帐户，您也应该这样做：|2349504|UPDATE+mysql.user+SET+Password=PASSWORD('newpwd')+WHERE+User='root';|2349505|一旦收到指示成功查询(受影响的一个或多个行)的消息，刷新权限：|2349506|FLUSH+PRIVILEGES;|2349507|然后停止mysqld过程，用经典的方式重新启动它：|2349508|sudo+/etc/init.d/mysql+stop
sudo+/etc/init.d/mysql+start|2349509|这是从https://help.ubuntu.com/community/MysqlPasswordReset借来的，您也可以检查另一种方法来重置mysql密码。|offset|length|2349510|entityMap|0|LINK|mutability|MUTABLE|url|https://help.ubuntu.com/community/MysqlPasswordReset^0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|3|1G|0|0^^$0|@$1|2|3|4|5|6|7|1N|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|1O|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|1P|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|1Q|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|M|7|1R|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|1S|8|@]|9|@]|A|$]]|$1|P|3|Q|5|D|7|1T|8|@]|9|@]|A|$E|F]]|$1|R|3|S|5|6|7|1U|8|@]|9|@]|A|$]]|$1|T|3|U|5|D|7|1V|8|@]|9|@]|A|$E|F]]|$1|V|3|W|5|6|7|1W|8|@]|9|@]|A|$]]|$1|X|3|Y|5|D|7|1X|8|@]|9|@]|A|$E|F]]|$1|Z|3|10|5|6|7|1Y|8|@]|9|@]|A|$]]|$1|11|3|12|5|D|7|1Z|8|@]|9|@]|A|$E|F]]|$1|13|3|14|5|6|7|20|8|@]|9|@]|A|$]]|$1|15|3|16|5|D|7|21|8|@]|9|@]|A|$E|F]]|$1|17|3|18|5|6|7|22|8|@]|9|@]|A|$]]|$1|19|3|1A|5|D|7|23|8|@]|9|@]|A|$E|F]]|$1|1B|3|1C|5|6|7|24|8|@]|9|@$1D|25|1E|26|1|27]]|A|$]]|$1|1F|3|-4|5|6|7|28|8|@]|9|@]|A|$]]]|1G|$1H|$5|1I|1J|1K|A|$1L|1M]]]]

1) Stop the mysql demon process using this command :

<pre><code>sudo /etc/init.d/mysql stop
</code></pre>

2) Start the mysqld demon process using the --skip-grant-tables option with this command 

<pre><code>sudo /usr/sbin/mysqld --skip-grant-tables --skip-networking &amp;
</code></pre>

<blockquote>
 Because you are not checking user privs at this point, it's safest to
 disable networking. In Dapper, /usr/bin/mysqld... did not work.
 However, mysqld --skip-grant-tables did.
</blockquote>

1) start the mysql client process using this command 

<pre><code>mysql -u root
</code></pre>

2) from the mysql prompt execute this command to be able to change any password

<pre><code>FLUSH PRIVILEGES;
</code></pre>

3) Then reset/update your password 

<pre><code>SET PASSWORD FOR root@'localhost' = PASSWORD('password');
</code></pre>

4) If you have a mysql root account that can connect from everywhere, you should also do:

<pre><code>UPDATE mysql.user SET Password=PASSWORD('newpwd') WHERE User='root';
</code></pre>

once have received a message indicating a successful query (one or more rows affected), flush privileges:

<pre><code>FLUSH PRIVILEGES;
</code></pre>

Then stop the mysqld process and relaunch it with the classical way:

<pre><code>sudo /etc/init.d/mysql stop
sudo /etc/init.d/mysql start
</code></pre>

This is borrowed from <a href="https://help.ubuntu.com/community/MysqlPasswordReset" rel="nofollow">https://help.ubuntu.com/community/MysqlPasswordReset</a> , you can check also another method to reset mysql password.

blocks|key|2349557|text|看来您的MySQL服务器根本没有运行。你能检查一下吗？|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2349558|service+mysql+status|code-block|syntax|javascript|2349559|您需要尝试重新启动它，并确保可以停止并使用|2349560|service+mysql+stop
service+mysql+start|2349561|如果你有任何错误，请把它们贴在这里。|2349562|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|S|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

Looks like your MySQL server is not running at all.
Can you check it?

<pre><code>service mysql status
</code></pre>

You need to try restart it and make sure that you can stop and start it using

<pre><code>service mysql stop
service mysql start
</code></pre>

If you have any errors post them here please.

blocks|key|1596321|text|重新安装mysql服务器为我工作。(我正在使用mysql+5.7)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1596322|sudo+wget+http://repo.mysql.com/mysql-apt-config_0.8.9-1_all.deb
sudo+dpkg+-i+mysql-apt-config_0.8.9-1_all.deb
sudo+apt-get+update
sudo+apt-get+install+mysql-server
mysql_secure_installation|code-block|syntax|javascript|1596323|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Reinstalling mysql-server worked for me. (I am using mysql 5.7)

<pre><code>sudo wget http://repo.mysql.com/mysql-apt-config_0.8.9-1_all.deb
sudo dpkg -i mysql-apt-config_0.8.9-1_all.deb
sudo apt-get update
sudo apt-get install mysql-server
mysql_secure_installation
</code></pre>

blocks|key|2349573|text|第一个杀死用户|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2349574|sudo+pkill+-u+<user>|code-block|syntax|javascript|2349575|然后安装mysql服务器|2349576|sudo+apt+install+mysql-server|2349577|配置它|2349578|sudo+mysql_secure_installation|2349579|进入mysql+shell|2349580|sudo+mysql|2349581|entityMap^0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|W|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|X|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|Y|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|Z|8|@]|9|@]|A|$E|F]]|$1|O|3|P|5|6|7|10|8|@]|9|@]|A|$]]|$1|Q|3|R|5|D|7|11|8|@]|9|@]|A|$E|F]]|$1|S|3|-4|5|6|7|12|8|@]|9|@]|A|$]]]|T|$]]

first kill user

<pre><code>sudo pkill -u &lt;user&gt;
</code></pre>

Then install mysql server

<pre><code>sudo apt install mysql-server
</code></pre>

Configure it 

<pre><code>sudo mysql_secure_installation
</code></pre>

Enter into mysql shell

<pre><code>sudo mysql
</code></pre>

I am trying to run a local mysql server, on my own computer. I have lost the password that I initially set up. When I try to connect to mysql, I get the following error:
<blockquote>
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
</blockquote>
I have therefore tried <a href="https://ubuntu.flowconsult.at/en/mysql-set-change-reset-root-password/" rel="nofollow noreferrer">these steps</a> to reset my MySQL password, but the line
<blockquote>
mysql -u root mysql
</blockquote>
returns the same error message:
<blockquote>
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
</blockquote>
When running the command
<blockquote>
mysqladmin -u root -p status
I get the following message:
error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
</blockquote>
I have been checking and the file mentioned (/var/run/mysqld/mysqld.sock) doesn't actually exist. I am not sure what is causing this.
I have tried a couple of solutions online including <a href="https://stackoverflow.com/questions/11657829/error-2002-hy000-cant-connect-to-local-mysql-server-through-socket-var-run">this</a>, <a href="https://stackoverflow.com/questions/19658891/error-2002-hy000-cant-connect-to-local-mysql-server-through-socket-var-run">this</a>, <a href="https://stackoverflow.com/questions/4448467/cant-connect-to-local-mysql-server-through-socket-var-lib-mysql-mysql-sock">this</a> and <a href="https://stackoverflow.com/questions/5376427/cant-connect-to-local-mysql-server-through-socket-var-mysql-mysql-sock-38">this</a> but none of this solutions worked for me. I would like to add that mysql-server is installed on my machine.
Any help appreciated. Please accept my apologies if there is any confusion to the above statements. I tried to explain what is happening as much as I can, but I am a beginner and I am clueless as to what is happenening there.

Resetting MySQL password & missing mysqld.sock file

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

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

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

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

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

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

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

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

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

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

我正在尝试在我自己的计算机上运行本地mysql服务器。我丢失了我最初设置的密码。当我试图连接到mysql时，会得到以下错误：错误2002 (HY000)：无法通过套接字'/var/run/mysqld/mysqld.sock‘连接到本地MySQL服务器(2)因此，我尝试重置我的MySQL密码，但是行mysql -u根m...

问重置MySQL密码&丢失mysqld.sock文件
EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问重置MySQL密码&丢失mysqld.sock文件EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问重置MySQL密码&丢失mysqld.sock文件
EN