error1:mysql mysqld.sock文件丢失问题

本文分享了亲测有效的解决方案,针对Mysql通过socket连接失败和root用户在localhost上使用密码时的访问被拒绝的问题。提供了详细的步骤和可能的原因分析。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

1.亲测有效

Mysql -- connect MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
https://blog.youkuaiyun.com/ydm19891101/article/details/81665037

2.ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

(头疼,总是这个问题)

 

 

 

[zcc@localhost mysql]$ sudo systemctl status mysqlmysql.service - MySQL Community Server Loaded: loaded (/etc/systemd/system/mysql.service; enabled; vendor preset: disabled) Active: failed (Result: exit-code) since 四 2025-07-24 00:22:15 PDT; 5s ago Process: 99005 ExecStart=/usr/local/mysql/bin/mysqld_safe --datadir=/var/lib/mysql (code=exited, status=1/FAILURE) 7月 24 00:22:14 localhost.localdomain systemd[1]: Starting MySQL Community Server... 7月 24 00:22:15 localhost.localdomain mysqld_safe[99005]: /usr/local/mysql/bin/mysqld_safe:行653: /var/…不够 7月 24 00:22:15 localhost.localdomain systemd[1]: mysql.service: control process exited, code=exited s...s=1 7月 24 00:22:15 localhost.localdomain systemd[1]: Failed to start MySQL Community Server. 7月 24 00:22:15 localhost.localdomain systemd[1]: Unit mysql.service entered failed state. 7月 24 00:22:15 localhost.localdomain systemd[1]: mysql.service failed. Hint: Some lines were ellipsized, use -l to show in full. [zcc@localhost mysql]$ mysql -u root -p Enter password: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) [zcc@localhost mysql]$ sudo systemctl status mysqlmysql.service - MySQL Community Server Loaded: loaded (/etc/systemd/system/mysql.service; enabled; vendor preset: disabled) Active: failed (Result: exit-code) since 四 2025-07-24 00:22:15 PDT; 3min 45s ago Process: 99005 ExecStart=/usr/local/mysql/bin/mysqld_safe --datadir=/var/lib/mysql (code=exited, status=1/FAILURE) 7月 24 00:22:14 localhost.localdomain systemd[1]: Starting MySQL Community Server... 7月 24 00:22:15 localhost.localdomain mysqld_safe[99005]: /usr/local/mysql/bin/mysqld_safe:行653: /va…不够 7月 24 00:22:15 localhost.localdomain systemd[1]: mysql.service: control process exited, code=exited...s=1 7月 24 00:22:15 localhost.localdomain systemd[1]: Failed to start MySQL Community Server. 7月 24 00:22:15 localhost.localdomain systemd[1]: Unit mysql.service entered failed state. 7月 24 00:22:15 localhost.localdomain systemd[1]: mysql.service failed. 这个怎么解决
最新发布
07-25
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值