How to delete MySQL under Linux system

1. Back up the MySQL database

Before deleting the MySQL database, be sure to back up the database to avoid data loss caused by misoperation. You can use the following command for backup:

$ mysqldump -u root -p ––all-databases > all_dbs.sql

where root is the super administrator account of MySQL, and all_dbs.sql is the backup file name. Save the files to a safe location after the backup is complete.

2. Stop the MySQL service

You need to stop the MySQL service before deleting it. Use the following command to stop the MySQL service:

$ sudo systemctl stop mysql

3. Uninstall MySQL

Method 1: Use the apt-get command to uninstall MySQL

You can use the following command to uninstall MySQL:

$ sudo apt-get remove ––purge mysql-server mysql-client mysql-common

If other components are installed during the MySQL installation process, you can use the following command to uninstall:

$ sudo apt-get remove ––purge mysql-server mysql-client mysql-common <other components>

Method 2: Manually uninstall MySQL

Manual uninstallation is necessary if there are MySQL related components that have not been deleted after the apt-get command. Use the following command to view MySQL-related files and directories:

$ dpkg –S | grep mysql

Use the following command to delete MySQL-related files and directories:

$ sudo rm -rf <file/directory>

You can delete the following directories and files according to the above command:

• /etc/mysql/

• /var/lib/mysql/

• ##/var/log/ mysql

• /usr/bin/mysql

##/usr/sbin/mysql
/ usr/share/mysql
/root/.mysql_history
You need to restart the computer after the uninstallation is complete.

4. Check whether MySQL is completely deleted

After uninstalling MySQL, you need to check whether MySQL is completely deleted. Use the following command to check if MySQL is completely deleted:

$ sudo find / -iname 'mysql*' -exec rm -rf {} ;

This command will search every directory in the entire computer file system for files or directories containing "mysql" and delete them. After the command is checked, all MySQL-related files and directories are removed.

5. Install MySQL

If you need to reinstall MySQL, you can use the following command to install MySQL:

$ sudo apt-get update
$ sudo apt-get install mysql-server

6. Restore backup data

If you have already The MySQL database has been backed up and can be restored using the backup data. Use the following command to restore data:

$ mysql -u root -p < all_dbs.sql

Among them,

root

is the super administrator account of MySQL, and all_dbs.sql is the name of the data file previously backed up.

The above is the detailed content of How to delete MySQL under Linux system. For more information, please follow other related articles on the PHP Chinese website!