Question

Ubuntu 14.04 MySQL 5.6 Upgrade Issue: Can't Start MySQL

Posted on April 12, 2017
MySQL Ubuntu
Asked by 69dcffc7148d4903a510d20b659a09

I have a droplet that I had installed MySQL 5.5 upon initial setup of server a year or so ago but haven’t needed MySQL until recently. First, I wanted to update to 5.6 as it was what the project called for. So I ssh’d into the server and made sure everything was in working order first; logged into mysql, looked at the default test db etc, all was well. So I went on to updating:

sudo apt-get update
sudo apt-get upgrade
sudo apt-get install mysql-server-5.6

Everything appeared to be going fine, but upon exiting the install I get the following:

2017-04-12 15:00:51 0 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
2017-04-12 15:00:51 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-04-12 15:00:51 0 [Note] /usr/sbin/mysqld (mysqld 5.6.33-0ubuntu0.14.04.1) starting as process 6673 ...
start: Job failed to start
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: error processing package mysql-server-5.6 (--configure):
 subprocess installed post-installation script returned error exit status 1
E: Sub-process /usr/bin/dpkg returned an error code (1)

And when trying to connect to mysql (mysql -u root -p) I get:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)

I’ve completely uninstalled, reinstalled, cleaned, autocleaned, and am at a loss. I even tried uninstalling 5.6 and trying to go back to 5.5 but that results in the same as above. What have I done? And what can I do to resolve it?

Thanks!

Show comments

Submit an answer

This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Chuck Brown • April 12, 2017

Accepted Answer

If it were me I’d remove any instances of old MySQL configurations - it could just be something is configured from the old setup, is the error message still the same or has it changed at all?

trustfarminfo • April 18, 2018

In mycase ::

Ubuntu14.04 -> 16.04 upgrade.

MySQL db updates from old to 5.7 .

xxxxxxx start: Job failed to start invoke-rc.d: initscript mysql, action “start” failed. dpkg: error processing package mysql-server-5.7 (–configure): ‘thread-concurrency=10’ option was unknown to new version 5.7.

So, I edit /etc/mysql/my.cnf , comment out , add ‘#’ on ‘thread-concurrency=10’ option line.

and then it Works!.

When upgrading , May be there’s uncompatible option is exists. check the error logs and manually modify my.cnf first.

Good Luck.

Chuck Brown • April 12, 2017

If you have no active data in-use, have you tried moving the entire MySQL Data folder out of the equation and then re-install 5.6? So something like:

mv /var/lib/mysql/ /var/lib/mysql_old/

Then try the install again, seems like maybe old tables are causing the issues or an upgrade gone wrong some how, but try clearing the data and try it again.