dpkg always try to install mysql-server-5.7

Question

Whenever i try to install anything, it always install mysql-server-5.7.

I tried sudo apt-get install php-mbstring but it tried to install mysql-server-5.7 first. I don't know what is going wrong.

I am getting following errors

Reading package lists... Done
Building dependency tree       
Reading state information... Done
php-mbstring is already the newest version (1:7.0+35ubuntu6).
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
2 not fully installed or removed.
After this operation, 0 B of additional disk space will be used.
Do you want to continue? \[Y/n\] y
Setting up mysql-server-5.7 (5.7.13-0ubuntu0.16.04.2) ...
Renaming removed key_buffer and myisam-recover options (if present)
dpkg: error processing package mysql-server-5.7 (--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.7; however:
  Package mysql-server-5.7 is not configured yet.

dpkg: error processing package mysql-server (--configure):
 dependency problems - leaving unconfigured
No apport report written because the error message indicates its a followup error from a previous failure.
                                                                                                          Errors were encountered while processing:
 mysql-server-5.7
 mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)]

Here is the attached

Answer 1

I had had the same problem. In my case, it reveals that for some reasons I had the mysql-server running with sock file places in /tmp/something/ (maybe it was started by the dpkg, cause I dont have mysql enabled at startup?). I killed the mysqlserver (kill -9) and stared the mysql service just normal (service mysql start).

Then I run sudo dpkg --configure -a. While updating the script throw an error about to low "thread_stack" which was easy to change in mysqld.cnf (/etc/mysql). Restarted the mysql service, run dpkg --configure -a once again and voila - the upgrade went ok.

OS: Ubuntu16.04.1

Answer 2

I had a similar problem:

Dpkg: package error processing mysql-server (--configure): Dependency problems - leaving unconfigured Errors were Encountered while processing: mysql-server mysql-server-5.7

So I did as advised:

     sudo dpkg --configure mysql-server-5.7

And then I noticed:

Mysql_upgrade: Got error: 1045: Access denied for user 'Debian-sys-maint' @ 'localhost' (using password: YES) while connecting To the MySQL server

So, I only needed to add the rights for Debian-sys-maint user.

A blog post explains very well the details of the reasoning and approach (in French) : http://www.linuxaddict.fr/index.php/2013/12/24/comment-regler-lerreur-dacces-de-debian-sys-maint-dans-mysql/

To summerize it :

• Edit /etc/mysql/my.cnf and uncomment theise lines or add them to enable mysql loging in order to understant what happened :

general_log_file = /var/log/mysql/mysql.log
general_log = 1

• Restart mysql service :

sudo /etc/init.d/mysql reload

• Then I had that error (Access denied to the user) :

error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)'

• So, note the password in the file /etc/mysql/debian.cnf and grant privilege to that user :

mysql -u root -p
mysql>GRANT ALL PRIVILEGES ON . TO 'debian-sys-maint'@'localhost' IDENTIFIED BY 'Your password';

mysql>FLUSH PRIVILEGES;
mysql>exit
mysql>bye

• Restart mysql and try again your installation :

sudo /etc/init.d/mysql restart