I had a broken installation of mariadb over mysql 5.5. For hours i have tried to reinstall mysql with the usage of apt-get - tried to purge, remove etc everything mysql related. Uninstalled php aswell. Apache got reinstalled too. Every single install was throwing errors during mysql-server configuration. I finally managed to perform a succesfull installation from deb package from website. I ran this after the package was installed:
sudo apt-get install mysql-server-5.5
Installtion failure part:
Setting up mysql-server-5.5 (5.5.35-0ubuntu0.12.04.2) ...
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
No apport report written because MaxReports is reached already
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 MaxReports is reached already
Setting up libmariadbclient18 (10.0.8+maria-1~precise) ...
Processing triggers for libc-bin ...
ldconfig deferred processing now taking place
Errors were encountered while processing:
mysql-server-5.5
mysql-server
All right, so I ran sudo dpkg --configure mysql-server-5.5
and got
Setting up mysql-server-5.5 (5.5.35-0ubuntu0.12.04.2) ...
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
Errors were encountered while processing:
mysql-server-5.5
If we try to run mysql
we get
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Which guides me back to my.cnf manipulation and mysql reinstallation. Goddamn closed error circle.
I have tried every solution related to mysql installation I have found. Really running out of options here, reinstalling and configuring ubuntu would be easier and faster. Any feedback appreciated.
EDIT: One notice - why am I prompted for mysql admin password 3 times during an installation?