pull down to refresh
deleted by author
reply
are you on apache or nginx? can you share the specs of your server on cotabo? I should have ask earlier...
In the meantime, let's repair partially installed packages
sudo dpkg --configure -aFix broken dependencies
sudo apt-get install -fClean cached packages (optional)
sudo apt-get cleanRetry installing mysql-server (maybe not needed)
sudo apt-get install --reinstall mysql-server-8.0reply
are you on apache or nginx? can you share the specs of your server on cotabo? I should have ask earlier...
idk, how could I look it up 👀
deleted by author
reply
is mysql still running?
sudo systemctl stop mysqlsudo 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 autocleanThen let's try to reinstall MySQL
sudo apt-get update
sudo apt-get install mysql-server-8.0Hopefully ithis succeeds! Verify with:
sudo systemctl status mysqlreply
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.sockThen continue with reinstalling mysql
sudo apt-get update
sudo apt-get install mysql-server-8.0And finger crossed will be running!
sudo systemctl status mysqlreply
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
sudo systemctl stop apache2ORsudo systemctl stop nginxif you are using nginx, andsudo systemctl stop mysqlsudo systemctl disable apache2(assuming is an apache server) andsudo systemctl disable mysql