ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/usr/local/mysql/run/mysql.sock.lock' (111) [root@localhost ~]#

引用:ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
引用:ERROR 2002: Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (111)
引用:在网上看到各种教程,都会出现ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock'

根据引用内容，你遇到的问题是无法通过MySQL的socket连接到本地的MySQL服务器。错误提示中的socket路径可能因系统或配置不同而有所差异。

解决这个问题的一种方法是通过命令行工具mysqladmin来重置密码。你可以在终端中运行以下命令：
/usr/local/mysql/bin/mysqladmin -u root -S /var/lib/mysql/mysql.sock password 'your.passwd'

其中，/usr/local/mysql/bin/mysqladmin是mysqladmin工具的路径，-u root表示使用root用户，-S /var/lib/mysql/mysql.sock表示指定socket路径，password 'your.passwd'表示设定你的密码。

另外，在网上的教程中也有提到类似的问题，如ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock'。这些问题可能出现的原因有很多，比如MySQL服务器没有启动、socket文件不存在或权限问题等。解决方法也因具体原因而异，所以你需要根据你的具体情况进行调整和尝试。<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* [解决Can‘t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock‘ (2)](https://blog.csdn.net/m0_47505062/article/details/122761275)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 33.333333333333336%"]
- *2* [Can’t connect to local MySQL through socket ‘/tmp/mysql.sock’解决方法](https://download.csdn.net/download/weixin_38677936/14837586)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 33.333333333333336%"]
- *3* [ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)](https://blog.csdn.net/qw_xingzhe/article/details/78699157)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 33.333333333333336%"]
[ .reference_list ]