Sometimes we face issues with MySQL installation on a Linux system. If we simply remove MySQL packages and re-install doesn’t fix the issue, in that case, old settings may still exist on the server which again affects the new install. In that case, first, uninstall MySQL completely from the system and erase all settings of the old install. To do the same follow the below settings.
Note: Please do not use the below steps if MySQL has any running databases.
Step 1 – Uninstall MySQL Packages
First, uninstall all the MySQL packages installed on your server. Use one of the following commands as per your Linux distribution. The package names may vary based on the Operating system and installation types.
sudo yum remove mysql mysql-server #CentOS and RedHat systems sudo apt remove mysql mysql-server #Ubuntu and Debian systems sudo dnf remove mysql mysql-server #Fedora 22+ systems
Step 2 – Romove MySQL Directory
Now we need to remove MySQL data directory from system which by default exists at /var/lib/mysql. If you didn’t find this, It may be changed to some other place, which you can find in my.cnf file with variable datadir. Delete the /var/lib/mysql directory from the system but we prefer to rename it to keep a backup of existing files.
sudo mv /var/lib/mysql /var/lib/mysql_old_backup sudo mv /etc/mysql /etc/mysql_old_backup
Step 3 – Reinstall MySQL (If Required)
After removing MySQL completely, install it again using package manager, It will recreate all the required directories on your system. Below are the commands to install MySQL from default package repositories.
sudo yum install mysql-server #CentOS and RedHat systems sudo apt install mysql-server #Ubuntu and Debian systems sudo dnf install mysql-server #Fedora 22+ systems
After completing the above steps, now you have a fresh MySQL install on your system with new settings.