☰

从 18.04 升级到 20.04 LTS 后无法连接到 mysql 本地数据库

tag-icon • tag-icon mysql 20.04
从 18.04 升级到 20.04 LTS 后无法连接到 mysql 本地数据库

我无法连接到 MYSQL db，它是一个根进程：

我已经尝试过解决办法：

  1. https://dba.stackexchange.com/questions/11027/cant-connect-to-local-mysql-server-through-socket-var-lib-mysql-mysql-sock

但失败了

mysql服务器状态：

mysql.service - MySQL Community Server
 Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
 Active: failed (Result: exit-code) since Tue 2020-05-26 15:01:53 IST; 23min ago
Process: 1470 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
Process: 1479 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/run/mysqld/mysqld.pid (code=exited, status=1/FAILURE)

May 26 15:01:53 user systemd[1]: 
mysql.service: Scheduled restart job, restart counter is at 6.
May 26 15:01:53 user systemd[1]: Stopped MySQL Community Server.
May 26 15:01:53 user systemd[1]: mysql.service: Start request repeated too quickly.
May 26 15:01:53 user systemd[1]: mysql.service: Failed with result 'exit-code'.
May 26 15:01:53 user systemd[1]: Failed to start MySQL Community Server.

相关内容