☰

无法为 MySQL“root”用户设置密码，启动：作业无法启动

tag-icon • tag-icon server software-installation mysql
无法为 MySQL“root”用户设置密码，启动：作业无法启动 
     ┌───────────────────────Configuring mysql-server-5.5─────────────────────────┐
     │ Unable to set password for the MySQL "root" user                           │
     │                                                                            │
     │ An error occurred while setting the password for the MySQL                 │
     │ administrative user. This may have happened because the account already    │
     │ has a password, or because of a communication problem with the MySQL       │
     │ server.                                                                    │
     │                                                                            │ 
     │ You should check the account's password after the package installation.    │
     │                                                                            │ 
     │ Please read the /usr/share/doc/mysql-server-5.5/README.Debian file for     │ 
     │ more information.                                                          │ 
     │                                                                            │
     │                                                                            │
     ├────────────────────────────────────────────────────────────────────────────┤ 
                                      │ < OK > │ 
     └────────────────────────────────────────────────────────────────────────────┘
start: Job failed to start 
invoke-rc.d: initscript mysql, action "start" failed. 
dpkg: error processing package mysql-server-5.5 (--configure):
 subprocess installed post-installation script returned error exit status 1 
dpkg: dependency problems prevent configuration of mysql-server:
 mysql-server depends on mysql-server-5.5; however:
  Package mysql-server-5.5 is not configured yet.

dpkg: error processing package mysql-server (--configure):
 dependency problems - leaving unconfigured 
Processing triggers for libc-bin (2.19-0ubuntu6.6) ... 
Processing triggers for ureadahead (0.100.0-16) ... 
Errors were encountered while processing:
 mysql-server-5.5
 mysql-server 
E: Sub-process /usr/bin/dpkg returned an error code (1)

我ps -e | grep mysqld在此之后发出了请求，但没有得到任何输出。

我已尝试以下所有方法，但问题仍然存在：

dpkg -S etc/mysql
aptitude purge mysql-server --purge-unused
sudo apt-get remove --purge mysql-server mysql-client mysql-common
sudo apt-get autoremove
sudo apt-get autoclean
sudo rm -rf /var/lib/mysql
sudo rm -rf /etc/mysql
sudo dpkg --configure -a
sudo apt-get update

我也尝试过这个，但没有成功：

sudo apt-get purge mysql-server mysql-client mysql-common mysql-client-5.5 mysql-server-5.5 
sudo dpkg -i mysql-5.6.13-debian6.0-i686.deb 
sudo apt-get install mysql-server

我该如何继续？

答案1

很难看出您的系统实际配置如何，因为您尝试了所有命令。您是否/usr/share/doc/mysql-server-5.5/README.Debian按照第一部分的建议阅读了？

无论如何，我会尝试： sudo dpkg-reconfigure mysql

这将使您有机会输入 MySQL 的 root 密码（不要与 Linuxroot用户混淆）。

如果成功，启动MySQL： sudo service mysql start

相关内容