19

I have unsuccessfully been attempting to install mysql-server for a while on my ubuntu vps

During a fresh install (Fully purged all mysql related packages) partway through the installation it asks for the root password to be set after which it presents an error screen containing:

An error occurred while setting the password for the MySQL administrative user. This may have happened because the account already has a password, or because of a communication problem with the MySQL server.

Unpacking mysql-server (from .../mysql-server_5.5.34-0ubuntu0.12.04.1_all.deb) ...
Processing triggers for man-db ...
Setting up libmysqlclient18 (5.5.34-0ubuntu0.12.04.1) ...
Setting up libdbd-mysql-perl (4.020-1build2) ...
Setting up mysql-client-core-5.5 (5.5.34-0ubuntu0.12.04.1) ...
Setting up mysql-client-5.5 (5.5.34-0ubuntu0.12.04.1) ...
Setting up mysql-server-core-5.5 (5.5.34-0ubuntu0.12.04.1) ...
Setting up mysql-server-5.5 (5.5.34-0ubuntu0.12.04.1) ...
131130 18:01:34 [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.
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
Processing triggers for libc-bin ...
No apport report written because the error message indicates its a followup error from a previous failure.
                          ldconfig deferred processing now taking place
Errors were encountered while processing:
 mysql-server-5.5
 mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)

I have attempted a few fixes involving apparmor related stuff before I realised that apparmor is not mentioned in the error logs unlike alot of other people having similar issues.

Any help on this matter would be greatly appreciated.

Edit:

Any attempts to continue or configure the installation after this point are simply met with further error messages

Braiam
  • 69,112
user216845
  • 191

3 Answers3

29

Try to purge all dependencies and re-install mysql-server. 

sudo apt-get purge mysql-server mysql-client mysql-common mysql-server-5.5
sudo apt-get install mysql-server
kiri
  • 28,986
user233437
  • 291
3

Open your terminal and type this 

 sudo dpkg --configure mysql-server-5.5

it also mentioned that some dependencies issues are there

sudo apt-get install -f

can help you to fix that issue.

Raja G
  • 105,327
  • 107
  • 262
  • 331
1

Actually, the following bug report helped me a lot: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=739846

The following commands should do the job:

echo "exit 0" >> /etc/init.d/mysql
dpkg --configure -a

However I had to configure it twice (the 2nd command).

bdesham
  • 343
user2177347
  • 19