I unfortunately messed up my mysql installation, when I thought I could just install mariadb next to it. Now I am not even able to remove and re-install it. As I have a lot of other things set up in this system I would like to avoid to freshly install Ubuntu.
So far I tried everything that was proposed in this answer and also what is proposed here. However I end up with the following error message:
What can I do to rescue the system. I don't care about the data in the sql database as this is gone for good now I believe.
When trying to sudo dpkg --purge --force-all mysql-server
and sudo apt install mysql-server
I get the error message:
update-alternatives: error: alternative path /etc/mysql/mysql.cnf doesn't exist
dpkg: error processing package mysql-server-5.7 (--configure):
subprocess installed post-installation script returned error exit status 2
dpkg: dpendency problems prevent configuration of mysql-server:
mysql-server depends on mysql-server-5.7; however:
Package mysql-server-5.7 is not configured yet.
dpkg: error processing package mysql-server (--configured):
dependency problems - leaving unconfigured
No apport repport written because the error message indicates its a followup error from a previous failure.
Errors were encountered while processing:
mysql-server-5.8
mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)
/etc/mysql/my.cnf
. That comes as part ofmysql-common
package. Consider doingapt-get remove --purge mysql-server
first then try installing thatmysql-common
package , and finally reinstalling server and client packagesudo apt-get remove --purge
it saySetting up mysql-server-5.7
and then tells mealternative path /etc/mysql/mysql.cnf
does not exist. It also saysmy-sql-server-5.7 is not configured yet
and ends with/usr/bin/dpkg returned an error code (1)
sudo dpkg-reconfigure mysql-server
ormysql-server-5.7
return anything meaningful ?sudo dpkg --purge --force-all mysql-server