Getting mySQL server back on Ubuntu 12.04

[rgonnering]

I had the same symptons as mthornton. The solution that leandroqm proposed worked great.

sudo apt-get clean

sudo apt-get autoclean

sudo apt-get remove --purge mysql-client-5.5 mysql-client-core-5.5 mysql-common mysql-server mysql-server-5.5 mysql-server-core-5.5

sudo apt-get install mysql-server

Rant: I upgraded to 12.04, and all I can say is it sucks, and Unity is an abomination. Switching workspaces and applications is cumbersome, and there is effectively no configuration capability. People who want eye-candy can buy a Mac.

[nacktduscher]

Thanks folks,
this thread is an extremly usefull one! Not so common these days, but this solution worked for me. So, good job !!!

And btw,I AM happy with Ubuntu AND Unity, because i started with Linux at times when the final clou after installing linux on a Systems was:

"root&: have fun ! "

This System today is not just "eye-candy" but Usability! It's in fact the first Linux that can be marketed to customers without except, because people don't have to be computer scientist to do effective work with it. And that counts on propagation, so we will have to make some compromise.

[archonic_one]

I've tried

sudo apt-get clean

sudo apt-get autoclean

sudo apt-get remove --purge mysql-client-5.5 mysql-client-core-5.5 mysql-common mysql-server mysql-server-5.5 mysql-server-core-5.5

sudo apt-get install mysql-server

I'm still getting the same results as before which are identical to mthorntons.

 
apt-get install -f mysql-server
Reading package lists... Done
Building dependency tree
Reading state information... Done
mysql-server is already the newest version.
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.5 (5.5.24-0ubuntu0.12.04.1) ...
120907 21:37:15 [Note] Plugin 'FEDERATED' is disabled.
120907 21:37:15 InnoDB: The InnoDB memory heap is disabled
120907 21:37:15 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120907 21:37:15 InnoDB: Compressed tables use zlib 1.2.3.4
120907 21:37:15 InnoDB: Initializing buffer pool, size = 128.0M
120907 21:37:15 InnoDB: Completed initialization of buffer pool
120907 21:37:15 InnoDB: highest supported file format is Barracuda.
120907 21:37:15  InnoDB: Waiting for the background threads to start
120907 21:37:16 InnoDB: 1.1.8 started; log sequence number 154164236
120907 21:37:16  InnoDB: Starting shutdown...
120907 21:37:16  InnoDB: Shutdown completed; log sequence number 154164236
start: Job failed to start
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: error processing mysql-server-5.5 (--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.5; however:
  Package mysql-server-5.5 is not configured yet.
dpkg: error processing mysql-server (--configure):
 dependency problems - leaving unconfigured
No apport report written because the error message indicates its a followup error from a previous failure.
                                                                                                          Er                   rors were encountered while processing:
 mysql-server-5.5
 mysql-server

In addition:

dpkg-reconfigure mysql-server-5.5
/usr/sbin/dpkg-reconfigure: mysql-server-5.5 is broken or not fully installed

Anyone else in my boat? I've been searching for a few hours and tried everything reasonable I've found.

[J0llyr0ger]

UGH I have the same issue, I've tried every suggestion I could find, uninstalled and reinstalled mysql many times, and always with the same result.

HELP!!

[archonic_one]

It's unfortunate this thread is marked as solved! There's some reputation and endless gratitude to anyone that provides the answer to this problem on superuser:
superuser.com/questions/502822/cant-start-mysql5-5-on-ubuntu-12-04-dpkg-dependency-problems

If there's no love by tomorrow I'll check for an unsolved thread or post a new one.

[lads]

Looking at the logs it seems to me the issue reported here by archonic_one is different from what I had. In my case mysql-server-5.5 was not even installing, while for archonic_one it installs but configuration fails.

I tried a bunch of other things before finding the proper solution, maybe the folk having this later issue could also try those. Apart from that I can't help much more.

Good luck.

[archonic_one]

Thanks for the reply. I've started a new thread for my issue (and hopefully others') here:
http://ubuntuforums.org/showthread.php?t=2084083

[hvnsweeting]

I 've solved this problem by not enter anything when it ask for root password when run apt-get purge mysql-server

[ceadams]

I 've solved this problem by not enter anything when it ask for root password when run apt-get purge mysql-server

I was getting this error because my loopback device was up but not responding (OpenVZ). If your /var/log/mysql/error.log has this while installing:

130622 19:49:42 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306130622 19:49:42 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
130622 19:49:42 [Note] Server socket created on IP: '127.0.0.1'.
130622 19:49:42 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address
130622 19:49:42 [ERROR] Do you already have another mysqld server running on port: 3306 ?
130622 19:49:42 [ERROR] Aborting

Try this

ifconfig lo up

Then re-try

apt-get install mysql-server

If that works, then you'll want to make sure the loopback interface comes up on reboot. The work-around can be found here: http://forum.openvz.org/index.php?t=msg&goto=26825&

A further tweak to the above:

Some init scripts (postfix in particular, in my case) expect the network interfaces to be available when they run, and rc.local is running too late (priority 99) in the init order.

So I've moved the contents of the rc.local script posted earlier into a new /etc/init.d/networking-restart script, and set its priority to S15/K85, so that it runs before most other init scripts. (It could probably go earlier; I just chose 15 because it was before ssh and postfix.) The following installs the new init script into the init start/stop queues:

Code: [Select all] [Show/ hide]

update-rc.d networking-restart start 15 2 3 4 5 . stop 85 0 1 6 .


Again, this doesn't solve the issue, only provides a work-around, each step a little better than the previous. I don't know how to incorporate this into the official Ubuntu image, but I would be pleased to see it. And, of course, suggestions for further improvements are welcomed.

[Stanislav Yotov]

Run one by one the commands bellow, and not all together.

sudo apt-get remove --purge mysql-server mysql-client mysql-common mysql-client-*

sudo apt-get autoremove sudo

apt-get autoclean

#make sure you have backed up everything before you run this:

rm -rf /var/lib/mysql
rm -rf /etc/mysql*

sudo dpkg-reconfigure mysql-server-5.5

I found most usefull:
http://askubuntu.com/questions/12568...stallation-etc

and to some extend :
http://knowledgelayer.softlayer.com/...ix-environment