I tried to change my lamp server from mysql to mariadb, because my teacher decided to use mariadb instead.
I'm on Ubuntu 20.04
I installed lamp using https://doc.ubuntu-fr.org/lamp, and removed mysql with
$ sudo apt remove --purge mysql-server
I tried then installing mariadb-server via $ sudo apt install mariadb-server but when running it it didn't worked.
I removed it the same way I removed mysql, and tried to reinstall it again $ sudo apt install mysql-server
But now I get this error
systemctl start mysql
Job for mysql.service failed because the control process exited with error code.
See "systemctl status mysql.service" and "journalctl -xe" for details.
I tried to full purge it
sudo service mysql stop
sudo apt-get remove --purge *mysql\*
sudo apt-get remove --purge mysql-server mysql-client mysql-common -y
sudo rm -rf /etc/mysql
sudo apt-get autoremove
sudo apt-get autoclean
sudo reboot
and reinstall it again
no change, same error
I typed journalctl -xe , and it gave me this
-- Subject: L'unité (unit) mysql.service a commencé à démarrer
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- L'unité (unit) mysql.service a commencé à démarrer.
déc. 13 15:37:39 miaku-VivoBook-ASUSLaptop-X515EA-X515EA mysql-systemd-start[6879]: MySQL has been frozen to prevent damage to your system. Please see /etc/mysql/FROZEN for help.
déc. 13 15:37:39 miaku-VivoBook-ASUSLaptop-X515EA-X515EA systemd[1]: mysql.service: Control process exited, code=exited, status=1/FAILURE
-- Subject: Unit process exited
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- An ExecStartPre= process belonging to unit mysql.service has exited.
--
-- The process' exit code is 'exited' and its exit status is 1.
déc. 13 15:37:39 miaku-VivoBook-ASUSLaptop-X515EA-X515EA systemd[1]: mysql.service: Failed with result 'exit-code'.
-- Subject: Unit failed
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- The unit mysql.service has entered the 'failed' state with result 'exit-code'.
déc. 13 15:37:39 miaku-VivoBook-ASUSLaptop-X515EA-X515EA systemd[1]: Failed to start MySQL Community Server.
-- Subject: L'unité (unit) mysql.service a échoué
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- L'unité (unit) mysql.service a échoué, avec le résultat failed.
déc. 13 15:37:39 miaku-VivoBook-ASUSLaptop-X515EA-X515EA systemd[1]: mysql.service: Scheduled restart job, restart counter is at 5.
-- Subject: Le redémarrage automatique d'une unité (unit) a été planifié
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- Le redémarrage automatique de l'unité (unit) mysql.service a été planifié, en
-- raison de sa configuration avec le paramètre Restart=.
déc. 13 15:37:39 miaku-VivoBook-ASUSLaptop-X515EA-X515EA systemd[1]: Stopped MySQL Community Server.
-- Subject: L'unité (unit) mysql.service a terminé son arrêt
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- L'unité (unit) mysql.service a terminé son arrêt.
déc. 13 15:37:39 miaku-VivoBook-ASUSLaptop-X515EA-X515EA systemd[1]: mysql.service: Start request repeated too quickly.
déc. 13 15:37:39 miaku-VivoBook-ASUSLaptop-X515EA-X515EA systemd[1]: mysql.service: Failed with result 'exit-code'.
-- Subject: Unit failed
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- The unit mysql.service has entered the 'failed' state with result 'exit-code'.
déc. 13 15:37:39 miaku-VivoBook-ASUSLaptop-X515EA-X515EA systemd[1]: Failed to start MySQL Community Server.
-- Subject: L'unité (unit) mysql.service a échoué
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- L'unité (unit) mysql.service a échoué, avec le résultat failed.
déc. 13 15:37:51 miaku-VivoBook-ASUSLaptop-X515EA-X515EA pkexec[6885]: pam_unix(polkit-1:session): session opened for user root by (uid=1000)
déc. 13 15:37:51 miaku-VivoBook-ASUSLaptop-X515EA-X515EA pkexec[6885]: miaku: Executing command [USER=root] [TTY=unknown] [CWD=/home/miaku] [COMMAND=/usr/lib/update-notifier/package-system-locked]
I don't really know what to do anymore, I 've heard mysql and mariadb where kinda hell to remove / reinstall, but I wasn't expecting it not working even after a full purge and reinstall, or I'm missing something ?
