pull down to refresh

is mysql still running?

sudo systemctl stop mysql
sudo apt-get purge mysql-server-8.0 mysql-client mysql-common mysql-server-core-8.0
sudo rm -rf /etc/mysql /var/lib/mysql /var/log/mysql
sudo apt-get autoremove
sudo apt-get autoclean

Then let's try to reinstall MySQL
sudo apt-get update
sudo apt-get install mysql-server-8.0

Hopefully ithis succeeds! Verify with:
sudo systemctl status mysql

reply

deleted by author

reply

it's ok, this is really testing my knowledge on server maintenance though 😅

Let's force it!
sudo apt-get purge mysql-* mariadb-*
sudo rm -rf /etc/mysql /var/lib/mysql /var/log/mysql /tmp/mysql.sock

Then continue with reinstalling mysql
sudo apt-get update
sudo apt-get install mysql-server-8.0

And finger crossed will be running!
sudo systemctl status mysql

reply

deleted by author

reply

Such relief... great! btw, maybe previous database now lost. But I assume you have still a backup/snapshot from the initial state.

Let's try again with cloudPanel

reply

deleted by author

reply

is mysql running? sudo systemctl status mysql?

Let's also clean previous cloudpanel installation:
sudo dpkg --remove --force-all cloudpanel

Then
sudo apt-get install -f
sudo dpkg --configure -a
to repair possible broken packages

and remove cp
sudo rm -rf /etc/cloudpanel /opt/cloudpanel

reply

no, it's inactive; and curious how to active it again?