Getting Error while reinstalling MYSQL

Question

I had my disk space full due to which I couldn’t delete binary logs using sql command. So, I took a backup deleted some bin files manually using SFTP. After this mysql start messing up, so I uninstalled and installed again but it isn’t working.

I ran following code to uninstall:

sudo apt-get purge mysql
sudo rm -rf /etc/mysql /var/lib/mysql
sudo apt-get autoremove
sudo apt-get autoclean
sudo rm -rf /var/lib/mysql
sudo rm -rf /etc/mysql

And for installing I followed this tutorial:

https://www.digitalocean.com/community/tutorials/how-to-install-mysql-on-ubuntu-20-04

And now I getting an error

“Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)”

Please help me out

Bobby Iliev · Accepted Answer

Hi there,

I could suggest following the steps from this answer here on how to completely uninstall MySQL:

https://www.digitalocean.com/community/questions/completely-uninstall-mysql-server

Let me know how it goes after that.

And if you are still seeing the error, can you check the MySQL status with:

sudo systemctl status mysql

And also check your MySQL error log and share the output here?

Best,

Bobby

Mohit Pandey · Answer

So, I tried uninstalling and reinstalling and I’m getting this error root@popular-quizz-0:~# sudo systemctl stop mysql root@popular-quizz-0:~# sudo apt purge mysql-server mysql-client mysql-common mysql-server-core-* mysql-client-core-* Reading package lists... Done Building dependency tree Reading state information... Done Note, selecting 'mysql-server-core-5.0' for glob 'mysql-server-core-*' Note, selecting 'mysql-server-core-5.1' for glob 'mysql-server-core-*' Note, selecting 'mysql-server-core-5.5' for glob 'mysql-server-core-*' Note, selecting 'mysql-server-core-5.6' for glob 'mysql-server-core-*' Note, selecting 'mysql-server-core-5.7' for glob 'mysql-server-core-*' Note, selecting 'mysql-server-core-8.0' for glob 'mysql-server-core-*' Package 'mysql-server-core-5.7' is not installed, so not removed Package 'mysql-server-core-5.5' is not installed, so not removed Package 'mysql-server-core-5.6' is not installed, so not removed Package 'mysql-server-core-5.0' is not installed, so not removed Package 'mysql-server-core-5.1' is not installed, so not removed Note, selecting 'mysql-client-core-5.0' for glob 'mysql-client-core-*' Note, selecting 'mysql-client-core-5.1' for glob 'mysql-client-core-*' Note, selecting 'mysql-client-core-5.5' for glob 'mysql-client-core-*' Note, selecting 'mysql-client-core-5.6' for glob 'mysql-client-core-*' Note, selecting 'mysql-client-core-5.7' for glob 'mysql-client-core-*' Note, selecting 'mysql-client-core-8.0' for glob 'mysql-client-core-*' Package 'mysql-client-core-5.7' is not installed, so not removed Package 'mysql-client-core-5.5' is not installed, so not removed Package 'mysql-client-core-5.6' is not installed, so not removed Package 'mysql-client-core-5.0' is not installed, so not removed Package 'mysql-client-core-5.1' is not installed, so not removed Package 'mysql-client-core-8.0' is not installed, so not removed Package 'mysql-server-core-8.0' is not installed, so not removed The following packages were automatically installed and are no longer required: libfwupdplugin1 libmecab2 linux-headers-5.4.0-105 linux-headers-5.4.0-105-generic linux-headers-5.4.0-107 linux-headers-5.4.0-107-generic linux-image-5.4.0-107-generic linux-modules-5.4.0-105-generic linux-modules-5.4.0-107-generic mecab-ipadic mecab-ipadic-utf8 mecab-utils mysql-community-client-core mysql-community-client-plugins mysql-community-server-core Use 'sudo apt autoremove' to remove them. The following packages will be REMOVED: mysql-client* mysql-common* mysql-community-client* mysql-community-server* mysql-server* 0 upgraded, 0 newly installed, 5 to remove and 3 not upgraded. 1 not fully installed or removed. After this operation, 43.5 MB disk space will be freed. Do you want to continue? [Y/n] y (Reading database ... 161033 files and directories currently installed.) Removing mysql-server (8.0.26-1ubuntu20.04) ... Removing mysql-community-server (8.0.26-1ubuntu20.04) ... update-alternatives: warning: alternative /etc/mysql/my.cnf.fallback (part of link group my.cnf) doesn't exist; removing from list of alternatives update-alternatives: warning: alternative /etc/mysql/mysql.cnf (part of link group my.cnf) doesn't exist; removing from list of alternatives update-alternatives: warning: /etc/alternatives/my.cnf is dangling; it will be updated with best choice Removing mysql-client (8.0.26-1ubuntu20.04) ... Removing mysql-community-client (8.0.26-1ubuntu20.04) ... Removing mysql-common (8.0.26-1ubuntu20.04) ... Processing triggers for man-db (2.9.1-1) ... (Reading database ... 160973 files and directories currently installed.) Purging configuration files for mysql-community-client (8.0.26-1ubuntu20.04) ... Purging configuration files for mysql-common (8.0.26-1ubuntu20.04) ... update-alternatives: error: no alternatives for my.cnf dpkg: error processing package mysql-common (--purge): installed mysql-common package post-removal script subprocess returned error exit status 2 Purging configuration files for mysql-community-server (8.0.26-1ubuntu20.04) ... . Errors were encountered while processing: mysql-common E: Sub-process /usr/bin/dpkg returned an error code (1) root@popular-quizz-0:~# sudo rm -rf /etc/mysql /var/lib/mysql /var/log/mysql root@popular-quizz-0:~# sudo rm -rf /etc/mysql /var/lib/mysql /var/log/mysql root@popular-quizz-0:~# sudo apt autoremove Reading package lists... Done Building dependency tree Reading state information... Done The following packages will be REMOVED: libfwupdplugin1 libmecab2 linux-headers-5.4.0-105 linux-headers-5.4.0-105-generic linux-headers-5.4.0-107 linux-headers-5.4.0-107-generic linux-image-5.4.0-107-generic linux-modules-5.4.0-105-generic linux-modules-5.4.0-107-generic mecab-ipadic mecab-ipadic-utf8 mecab-utils mysql-community-client-core mysql-community-client-plugins mysql-community-server-core 0 upgraded, 0 newly installed, 15 to remove and 3 not upgraded. After this operation, 583 MB disk space will be freed. Do you want to continue? [Y/n] y (Reading database ... 160942 files and directories currently installed.) Removing libfwupdplugin1:amd64 (1.5.11-0ubuntu1~20.04.2) ... Removing mecab-ipadic-utf8 (2.7.0-20070801+main-2.1) ... update-alternatives: using /var/lib/mecab/dic/ipadic to provide /var/lib/mecab/dic/debian (mecab-dictionary) in auto mode Removing mecab-ipadic (2.7.0-20070801+main-2.1) ... Removing mecab-utils (0.996-10build1) ... Removing mysql-community-server-core (8.0.26-1ubuntu20.04) ... Removing libmecab2:amd64 (0.996-10build1) ... Removing linux-headers-5.4.0-105-generic (5.4.0-105.119) ... Removing linux-headers-5.4.0-105 (5.4.0-105.119) ... Removing linux-headers-5.4.0-107-generic (5.4.0-107.121) ... Removing linux-headers-5.4.0-107 (5.4.0-107.121) ... Removing linux-image-5.4.0-107-generic (5.4.0-107.121) ... /etc/kernel/postrm.d/initramfs-tools: update-initramfs: Deleting /boot/initrd.img-5.4.0-107-generic /etc/kernel/postrm.d/zz-update-grub: Sourcing file `/etc/default/grub' Sourcing file `/etc/default/grub.d/50-cloudimg-settings.cfg' Sourcing file `/etc/default/grub.d/init-select.cfg' Generating grub configuration file ... Found linux image: /boot/vmlinuz-5.4.0-110-generic Found initrd image: /boot/initrd.img-5.4.0-110-generic Found linux image: /boot/vmlinuz-5.4.0-109-generic Found initrd image: /boot/initrd.img-5.4.0-109-generic done Removing linux-modules-5.4.0-105-generic (5.4.0-105.119) ... Removing linux-modules-5.4.0-107-generic (5.4.0-107.121) ... Removing mysql-community-client-core (8.0.26-1ubuntu20.04) ... Removing mysql-community-client-plugins (8.0.26-1ubuntu20.04) ... Processing triggers for man-db (2.9.1-1) ... Processing triggers for libc-bin (2.31-0ubuntu9.9) ... root@popular-quizz-0:~# sudo apt autoclean Reading package lists... Done Building dependency tree Reading state information... Done root@popular-quizz-0:~# sudo apt update Get:1 http://repo.mysql.com/apt/ubuntu focal InRelease [12.9 kB] Get:2 http://mirrors.digitalocean.com/ubuntu focal InRelease [265 kB] Hit:3 http://mirrors.digitalocean.com/ubuntu focal-updates InRelease Hit:4 https://repos.insights.digitalocean.com/apt/do-agent main InRelease Hit:5 https://repos-droplet.digitalocean.com/apt/droplet-agent main InRelease Hit:6 http://mirrors.digitalocean.com/ubuntu focal-backports InRelease Err:1 http://repo.mysql.com/apt/ubuntu focal InRelease The following signatures couldn't be verified because the public key is not available: NO_PUBKEY 467B942D3A79BD29 Hit:7 http://ppa.launchpad.net/ondrej/php/ubuntu focal InRelease Get:8 http://security.ubuntu.com/ubuntu focal-security InRelease [114 kB] Fetched 392 kB in 1s (575 kB/s) Reading package lists... Done Building dependency tree Reading state information... Done 3 packages can be upgraded. Run 'apt list --upgradable' to see them. W: An error occurred during the signature verification. The repository is not updated and the previous index files will be used. GPG error: http://repo.mysql.com/apt/ubuntu focal InRelease: The following signatures couldn't be verified because the public key is not available: NO_PUBKEY 467B942D3A79BD29 W: Failed to fetch http://repo.mysql.com/apt/ubuntu/dists/focal/InRelease The following signatures couldn't be verified because the public key is not available: NO_PUBKEY 467B942D3A79BD29 W: Some index files failed to download. They have been ignored, or old ones used instead. root@popular-quizz-0:~# sudo apt install mysql-server Reading package lists... Done Building dependency tree Reading state information... Done Some packages could not be installed. This may mean that you have requested an impossible situation or if you are using the unstable distribution that some required packages have not yet been created or been moved out of Incoming. The following information may help to resolve the situation: The following packages have unmet dependencies: mysql-server : Depends: mysql-server-8.0 but it is not going to be installed E: Unable to correct problems, you have held broken packages.

Question

Getting Error while reinstalling MYSQL

Become a contributor for community

DigitalOcean Documentation

Resources for startups and SMBs

Get our newsletter

The developer cloud

Get started for free