Kubuntu 22.04环境下MySQL服务启动失败及连接异常问题求助
大家好,我几个月前在自己的家用电脑上装了Kubuntu 22.04,刚才突然发现MySQL服务器没法正常工作了,试了几个排查命令都遇到了问题,具体情况如下:
- 直接执行
mysql命令尝试连接时,出现以下错误:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
- 尝试通过IP和端口指定连接:
root@master-at-home:/path# mysql -h 127.0.0.1 -P 3306 -u root
返回错误:
ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1:3306' (111)
- 尝试启动MySQL服务:
root@master-at-home:/path# sudo service mysql start
服务启动失败,提示:
Job for mysql.service failed because the control process exited with error code.
See "systemctl status mysql.service" and "journalctl -xeu mysql.service" for details.
- 查看MySQL服务状态:
root@master-at-home:/path# systemctl status mysql.service
输出结果为:
× mysql.service - MySQL Community Server
Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
Active: failed (Result: exit-code) since Sun 2024-10-27 09:33:42 EET; 10s ago
Process: 32412 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=1/FAILURE)
CPU: 2ms
目前我卡在服务启动失败这一步,有没有大佬能帮忙分析下问题根源,或者给一些具体的排查方向呀?
备注:内容来源于stack exchange,提问作者mstdmstd

