MySQL 无法在乌班图 22.04 中启动

Question

几天前，我在新安装的ubuntu 22.04上安装了LAMP，一切都很顺利。但今天当我尝试启动mysql时，它显示了以下错误。

mysql.service - MySQL Community Server
 Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
 Active: failed (Result: exit-code) since Sun 2022-05-01 09:35:16 IST; 19s ago
Process: 6471 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
Process: 6479 ExecStart=/usr/sbin/mysqld (code=exited, status=1/FAILURE)


Main PID: 6479 (code=exited, status=1/FAILURE)
     Status: "Server startup in progress"
      Error: 2 (No such file or directory)
        CPU: 312ms

May 01 09:35:16 g-pc systemd[1]: mysql.service: Scheduled restart job, restart counter is at 5.
May 01 09:35:16 g-pc systemd[1]: Stopped MySQL Community Server.
May 01 09:35:16 g-pc systemd[1]: mysql.service: Start request repeated too quickly.
May 01 09:35:16 g-pc systemd[1]: mysql.service: Failed with result 'exit-code'.
May 01 09:35:16 g-pc systemd[1]: Failed to start MySQL Community Server.

日记显示以下内容：

May 01 09:35:16 g-pc systemd[1]: mysql.service: Scheduled restart job, restart counter is at 5.
░░ Subject: Automatic restarting of a unit has been scheduled
░░ Defined-By: systemd
░░ Support: http://www.ubuntu.com/support
░░ 
░░ Automatic restarting of the unit mysql.service has been scheduled, as the result for
░░ the configured Restart= setting for the unit.
May 01 09:35:16 g-pc systemd[1]: Stopped MySQL Community Server.
░░ Subject: A stop job for unit mysql.service has finished
░░ Defined-By: systemd
░░ Support: http://www.ubuntu.com/support
░░ 
░░ A stop job for unit mysql.service has finished.
░░ 
░░ The job identifier is 3436 and the job result is done.
May 01 09:35:16 g-pc systemd[1]: mysql.service: Start request repeated too quickly.
May 01 09:35:16 g-pc systemd[1]: mysql.service: Failed with result 'exit-code'.
░░ Subject: Unit failed
░░ Defined-By: systemd
░░ Support: http://www.ubuntu.com/support
░░ 
░░ The unit mysql.service has entered the 'failed' state with result 'exit-code'.
May 01 09:35:16 g-pc systemd[1]: Failed to start MySQL Community Server.
░░ Subject: A start job for unit mysql.service has failed
░░ Defined-By: systemd
░░ Support: http://www.ubuntu.com/support
░░ 
░░ A start job for unit mysql.service has finished with a failure.
░░ 
░░ The job identifier is 3436 and the job result is failed.


 

Answer 1

经过几个小时的尝试，终于弄清楚了问题。此线程解决了该问题。我只是运行命令 sudo chown mysql：mysql -R /var/log/mysql .这解决了这个问题。