I'm having a problem with mysql installation which I can't resolve alone. First I tried to remove and purge old files with this command
sudo apt-get remove --purge mysql
sudo apt-get remove --purge mysql*
sudo apt-get remove --purge mariadb*
All 3 commands return same output ...
You might want to run 'apt-get -f install' to correct these: The following packages have unmet dependencies: dbconfig-mysql : Depends: mysql-client but it is not going to be installed or mariadb-client but it is not going to be installed or virtual-mysql-client E: Unmet dependencies. Try 'apt-get -f install' with no packages (or specify a solution).
So i run what is suggested me
apt-get -f install and I've got
$ sudo apt-get -f install Reading package lists... Done Building dependency tree Reading state information... Done Correcting dependencies... Done The following additional packages will be installed: mysql-server-5.7 Suggested packages: mailx tinyca The following NEW packages will be installed: mysql-server-5.7 0 upgraded, 1 newly installed, 0 to remove and 0 not upgraded. 1 not fully installed or removed. Need to get 0 B/2,597 kB of archives. After this operation, 48.3 MB of additional disk space will be used. Do you want to continue? [Y/n] y Preconfiguring packages ... (Reading database ... 300885 files and directories currently installed.) Preparing to unpack .../mysql-server-5.7_5.7.16-0ubuntu0.16.04.1_amd64.deb ... Aborting downgrade from (at least) 10.0 to 5.7. If are sure you want to downgrade to 5.7, remove the file /var/lib/mysql/debian-*.flag and try installing again. dpkg: error processing archive /var/cache/apt/archives/mysql-server-5.7_5.7.16-0ubuntu0.16.04.1_amd64.deb (--unpack): subprocess new pre-installation script returned error exit status 1 Errors were encountered while processing: /var/cache/apt/archives/mysql-server-5.7_5.7.16-0ubuntu0.16.04.1_amd64.deb E: Sub-process /usr/bin/dpkg returned an error code (1)
Same output I get when I run
apt upgrade -f. This is the output of
systemctl status mysql.service -l
$ systemctl status mysql.service -l ● mysql.service Loaded: not-found (Reason: No such file or directory) Active: failed (Result: exit-code) since Wed 2016-11-23 07:32:55 EET; 58min ago Nov 23 07:32:24 stan systemd: Starting LSB: Start and stop the mysql database server daemon... Nov 23 07:32:24 stan mysql: * Starting MariaDB database server mysqld Nov 23 07:32:55 stan mysql: ...fail! Nov 23 07:32:55 stan systemd: mysql.service: Control process exited, code=exited status=1 Nov 23 07:32:55 stan systemd: Failed to start LSB: Start and stop the mysql database server daemon. Nov 23 07:32:55 stan systemd: mysql.service: Unit entered failed state. Nov 23 07:32:55 stan systemd: mysql.service: Failed with result 'exit-code'.
Another thing I've tried was to remove
mysql-server and then install it again still same error.
Can anyone help with this issue.. I'm out of ideas how can I fix it.
Update output of
$ lsb_release -a No LSB modules are available. Distributor ID: Ubuntu Description: Ubuntu 16.04.1 LTS Release: 16.04 Codename: xenial
Update2: output of
sudo apt install mysql-server mysql-client
$ sudo apt install mysql-server mysql-client Reading package lists... Done Building dependency tree Reading state information... Done mysql-client is already the newest version (5.7.16-0ubuntu0.16.04.1). mysql-server is already the newest version (5.7.16-0ubuntu0.16.04.1). You might want to run 'apt-get -f install' to correct these: The following packages have unmet dependencies: mysql-server : Depends: mysql-server-5.7 but it is not going to be installed E: Unmet dependencies. Try 'apt-get -f install' with no packages (or specify a solution).