無法在 ubuntu 21.04 上運行 mysql

無法在 ubuntu 21.04 上運行 mysql

我在 ubuntu 21.04 上運行 mysql 遇到困難。我試過:

sudo apt remove --purge mysql-server
sudo apt purge mysql-server
sudo apt autoremove
sudo apt autoclean

sudo systemctl stop mysql
sudo apt purge mysql-server mysql-client mysql-common mysql-server-core-* mysql-client-core-*
sudo rm -rf /etc/mysql /var/lib/mysql /var/log/mysql
sudo apt autoremove
sudo apt autoclean

在重新安裝 mysql-server 之前:

sudo apt update
sudo apt install mysql-server

但無濟於事。問題是當我安裝時我在終端中得到這個:

Errors were encountered while processing:
 mysql-server-8.0
 mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)

當我運行時sudo mysql,我收到此錯誤:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

當我跑步時systemctl status mysql我得到:

mysql.service - MySQL Community Server
     Loaded: error (Reason: Unit mysql.service failed to load properly: Device or resource busy.)
     Active: failed (Result: exit-code) since Sun 2021-09-05 23:29:27 EET; 58min ago
   Main PID: 31191 (code=exited, status=1/FAILURE)
     Status: "Server startup in progress"

我試過:

sudo systemctl stop  mysql
sudo systemctl start  mysql

但我得到

Failed to start mysql.service: Unit mysql.service failed to load properly: Device or resource busy.
See system logs and 'systemctl status mysql.service' for details.

在 error.log 中我得到:

2021-09-05T22:26:37.674376Z 0 [錯誤] [MY-010262] [伺服器] 無法啟動伺服器:綁定在 TCP/IP 連接埠上:位址已在使用中

2021-09-05T22:26:37.674517Z 0 [錯誤] [MY-010257] [伺服器] 您是否已經有另一個 mysqld 伺服器在連接埠 3306 上執行?

2021-09-05T22:26:37.674808Z 0 [錯誤] [MY-010119] [伺服器] 正在中止

但是當我運行時,netstat -lp | grep 3306我發現在連接埠 3306 上沒有任何運行。 sudo kill -9 $(sudo lsof -t -i:3306)

關於如何解決這個問題有什麼想法嗎?

相關內容