Cannot install mysql on Ubuntu 17.10 Gnome 3.26.2

Question

Trying to install mysql, I always get the following error:

Errors were encountered while processing: /var/cache/apt/archives/mysql-server-5.7_5.7.21-0ubuntu0.17.10.1_amd64.deb E: Sub-process /usr/bin/dpkg returned an error code (1)

See in full below:

Reading package lists... Done
Building dependency tree       
Reading state information... Done
Suggested packages:
  mailx tinyca
The following NEW packages will be installed:
  mysql-server-5.7
0 upgraded, 1 newly installed, 0 to remove and 6 not upgraded.
Need to get 0 B/3,184 kB of archives.
After this operation, 48.3 MB of additional disk space will be used.
Preconfiguring packages ...
(Reading database ... 283762 files and directories currently installed.)
Preparing to unpack .../mysql-server-5.7_5.7.21-0ubuntu0.17.10.1_amd64.deb ...
Failed to stop mysql.service: Unit mysql.service not loaded.
invoke-rc.d: initscript mysql, action "stop" failed.
invoke-rc.d returned 5
There is a MySQL server running, but we failed in our attempts to stop it.
Stop it yourself and try again!
dpkg: error processing archive /var/cache/apt/archives/mysql-server-5.7_5.7.21-0ubuntu0.17.10.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.21-0ubuntu0.17.10.1_amd64.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)

I have tried this solution as well as almost every solution available on stackoverflow but it doesn't solve my problem Even mysql server is not entirely removed by sudo apt-get remove --purge mysql-server. I've to remove it by using synaptic manager

What worked for me: Disabling all the third party repositories and the following the linked question instruction again

If you have really tried "every solution available on stackoverflow", then please edit your question to tell us exactly what you tried, and exactly what each result was. — user535733, Mar 06 '18 at 00:01

score 0 · Answer 1 · answered Mar 05 '18 at 20:40

0

The mysql service is allready running on your system. try

sudo service mysql stop

or read this: How do I start/stop mysql server?

after that, you should check which version of mysql is installed and see if you actually need a different version.

answered Mar 05 '18 at 20:40

Glenn van Acker

185

Failed to stop mysql.service: Unit mysql.service not loaded. – Prabhat Sharma Mar 05 '18 at 20:59
Try to clean out the apt-cache too, you have 6 packages not upgraded, and 2 suggested packages. try apt-get clean and apt-get autoremove – Glenn van Acker Mar 05 '18 at 21:05
this maybe stupid, but have you tried simply rebooting your system? – Glenn van Acker Mar 05 '18 at 21:07
Nopes it didn't worked. I thing the main problem here is " Stopping mysql (via systemctl): mysql.serviceFailed to stop mysql.service: Unit mysql.service not loaded. failed!" – Prabhat Sharma Mar 05 '18 at 21:10
Nopes I've tried almost everything that is available on net but not rebooting – Prabhat Sharma Mar 05 '18 at 21:10
Now, I've tried rebooting. I didn't helped. Its showing unmet dependencies but apt --fix-broken install couldn't fix this – Prabhat Sharma Mar 05 '18 at 21:20
try to remove the broken packages, sudo apt-get remove -f , sudo dpkg --configure -a ,sudo apt-get clean, sudo apt-get update , sudo apt-get upgrade , sudo apt-get install -f – Glenn van Acker Mar 05 '18 at 21:33
Same error is encountered in all these commands :( – Prabhat Sharma Mar 05 '18 at 21:57
can you tell me which packages have unmet dependencies? also, do you have any third party repositories? – Glenn van Acker Mar 05 '18 at 23:21
mysql-server-5.7 itself has unmet dependency. I believe I do have some third party repo but not many I think some ppa and canonical repo are there – Prabhat Sharma Mar 06 '18 at 00:15
disable those repo's first before trying those commands again, could be they're the source of the dependency issues – Glenn van Acker Mar 06 '18 at 00:56
I've tried after disabling all the 3rd party repo but it didn't helped at all – Prabhat Sharma Mar 06 '18 at 08:59
keep them disabled until the system is clean. what unmet dependencies are there, and what are they conflicting with? – Glenn van Acker Mar 06 '18 at 13:08
Plz take a look at this https://pastebin.com/Q3iNYU68 – Prabhat Sharma Mar 07 '18 at 00:02
is mysql-common installed on your system? try removing mysql-server and mysql-server-5.7, then apt-get clean and apt-get autoremove and install them again. They were installed but not configured correctly. – Glenn van Acker Mar 07 '18 at 00:39
Thanks for your constant support @Glenn van Acker but this solved my problem https://answers.launchpad.net/ubuntu/+source/apt/+question/665275 – Prabhat Sharma Mar 07 '18 at 13:16
good, perhaps you can answer your own question here, and mark it, so others can benefit of this information? – Glenn van Acker Mar 07 '18 at 13:19

Cannot install mysql on Ubuntu 17.10 Gnome 3.26.2

1 Answers1