linux delete mysql

Under Linux systems, MySQL is one of the most commonly used database management systems. However, MySQL may also have some problems, such as taking up too much space, data errors, etc. In this case, MySQL needs to be deleted. This article will introduce 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

If the MySQL related components remain after using the apt-get command, you need to manually uninstall it. 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 whether MySQL is completely deleted:

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

This command will search for files or directories containing mysql in every directory in the entire computer file system 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 how to delete MySQL under Linux system. Be sure to back up your data before uninstalling MySQL, and check the removed components carefully to avoid misoperation.

The above is the detailed content of linux delete mysql. For more information, please follow other related articles on the PHP Chinese website!