卡住

Question

在我的系统上，由于未满足的依赖关系，我无法安装或删除使用apt-get的程序，但是我无法安装依赖项，因为我一直在获取错误：

Reading package lists... Done
Building dependency tree
Reading state information... Done
Correcting dependencies... Done
The following packages were automatically installed and are no longer required:
  galera-3 libdbi-perl mysql-server mysql-server-5.7
Use 'sudo apt autoremove' to remove them.
The following packages will be REMOVED:
  plesk-config-troubleshooter psa-imp
0 upgraded, 0 newly installed, 2 to remove and 4 not upgraded.
1 not fully installed or removed.
After this operation, 20.4 MB disk space will be freed.
Do you want to continue? [Y/n] y
(Reading database ... 118238 files and directories currently installed.)
Removing psa-imp (6.2.17-ubuntu16.04.build1705170314.14) ...
dpkg action:
 Trying to start service mysql... /usr/sbin/mysqld is stopped
done
 Trying to establish test connection... ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)

Trying to establish test connection... ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)只是重复了很多次，然后才说

failed

ERROR while trying to establish test connection
Check the error reason(see log file: /var/log/plesk/install/plesk_17.5.3_installation.log), fix and try again


establish test connection

***** installing problem report *****
ERROR while trying to establish test connection
Check the error reason(see log file: /var/log/plesk/install/plesk_17.5.3_installation.log), fix and try again
establish test connection
dpkg: error processing package plesk-config-troubleshooter (--remove):
 subprocess installed pre-removal script returned error exit status 1
Errors were encountered while processing:
 psa-imp
 plesk-config-troubleshooter
E: Sub-process /usr/bin/dpkg returned an error code (1)
W: Operation was interrupted before it could finish

这个问题与mysql有关，因为当我尝试从任何帐户运行mysql时，无论是用户帐户、管理员还是根用户，我都会得到相同的错误(用户名不同)。在互联网上查找修复程序之后，我尝试使用：mysqld --skip-grant-tables，然后是mysql -u root mysql，但是我只得到了ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)的相同错误。我也尝试了mysql -hxxx.xxx.xxx.xxx -uroot -p并得到了这个错误：ERROR 2003 (HY000): Can't connect to MySQL server on 'xxx.xxx.xxx.xxx' (111) (ip替换为xxx)

我也尝试过编辑/etc/my.cnf，这是我在另一个supposed中找到的，但是文件是空的，还有sudo dpkg-reconfigure mysql-server，它应该重置根密码，但是没有帮助。

Answer 1

我的sql似乎停止了，尝试启动服务，然后再工作一次。因为mysql停止了，所以您无法登录mysql。如果mysql有init脚本，可以通过sudo service mysql start或/etc/init.d/ mysql start启动mysql。