☰

無法啟動 mysql 社群伺服器 (5.7)

tag-icon • tag-icon server mysql
無法啟動 mysql 社群伺服器 (5.7)

所以最近在我重新安裝目錄後開始顯示新的錯誤/etc/mysql在我使用顯示的過程重新安裝它後，目錄看起來是正確的這裡，我使用了“恢復已刪除的目錄”方法。現在我啟動MySQL伺服器本身有問題，我不想卸載或重新安裝資料庫，因為我害怕丟失檔案。我將提供嘗試以安全方法解決此問題所需的所有詳細資訊。

錯誤詳情：

Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details.
invoke-rc.d: initscript mysql, action "start" failed.
● mysql.service - MySQL Community Server
   Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
   Active: activating (auto-restart) (Result: exit-code) since Sat 2019-12-21 16:59:38 EST; 5ms ago
  Process: 3942 ExecStartPost=/usr/share/mysql/mysql-systemd-start post (code=exited, status=0/SUCCESS)
  Process: 3941 ExecStart=/usr/sbin/mysqld (code=exited, status=2)
  Process: 3933 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
 Main PID: 3941 (code=exited, status=2)

Dec 21 16:59:38 ns529730 systemd[1]: Failed to start MySQL Community Server.
Dec 21 16:59:38 ns529730 systemd[1]: mysql.service: Unit entered failed state.
Dec 21 16:59:38 ns529730 systemd[1]: mysql.service: Failed with result 'exit-code'.
dpkg: error processing package mysql-server-5.7 (--configure):
 subprocess installed post-installation script returned error exit status 1
Errors were encountered while processing:
 mysql-server-5.7
E: Sub-process /usr/bin/dpkg returned an error code (1)

systemctl status 指令顯示：

root@ns529730:~# systemctl status mysql.service
● mysql.service - MySQL Community Server
   Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
   Active: activating (start-post) (Result: exit-code) since Sat 2019-12-21 17:10:40 EST; 14s ago
  Process: 6727 ExecStart=/usr/sbin/mysqld (code=exited, status=2)
  Process: 6720 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
 Main PID: 6727 (code=exited, status=2);         : 6728 (mysql-systemd-s)
   Memory: 15.0M
      CPU: 327ms
   CGroup: /system.slice/mysql.service
           └─control
             ├─6728 /bin/bash /usr/share/mysql/mysql-systemd-start post
             └─6784 mysqladmin ping

Dec 21 17:10:40 ns529730 systemd[1]: Starting MySQL Community Server...
Dec 21 17:10:41 ns529730 systemd[1]: mysql.service: Main process exited, code=exited, status=2/INVALIDARGUMENT

系統：Ubuntu 16.04 MySQL版本：5.7

答案1

好的，我透過innodb_force_recovery = 1在我的文件中的 [mysqld] 下新增來解決這個問題mysqld.cnf。您可以嘗試 1 到 10 之間的數字，因為第一次可能不起作用。另外，對於使用舊 mysql 版本的人，您應該在主配置文件上執行此操作，因為舊版本中有配置文件，etc/mysql/my.cnf但 5.7 mysql 版本中有它們etc/mysql/mysql.conf.d/mysqld.cnf 來自的答案這裡。完成編輯後，請嘗試使用以下命令啟動 mysql 伺服器sudo systemctl start mysql

相關內容