CentOS7环境卸载MySQL5.7

备份重要数据

切记，卸载之前先备份mysql重要的数据。

• 备份一个数据库

例如：备份名为mydatabase的数据库到backup.sql的文件中

mysqldump -u root -ppassword123 mydatabase > backup.sql

• 备份所有数据库

mysqldump -u root -ppassword123 --all-databases > all_databases_backup.sql

注意：-p后的password123是数据库密码，根据实际情况修改。

关闭mysql服务

[hadoop@node3 ~]$ sudo systemctl stop mysqld

卸载mysql

查看已安装的mysql包

[hadoop@node3 ~]$ rpm -qa|grep mysql
mysql-community-libs-5.7.16-1.el7.x86_64
mysql-community-common-5.7.16-1.el7.x86_64
mysql-community-libs-compat-5.7.16-1.el7.x86_64
mysql-community-server-5.7.16-1.el7.x86_64
mysql-community-client-5.7.16-1.el7.x86_64
[hadoop@node3 ~]$

使用yum卸载已安装的mysql

sudo yum remove -y mysql-community-libs-5.7.16-1.el7.x86_64
sudo yum remove -y mysql-community-common-5.7.16-1.el7.x86_64
sudo yum remove -y mysql-community-libs-compat-5.7.16-1.el7.x86_64
sudo yum remove -y mysql-community-server-5.7.16-1.el7.x86_64
sudo yum remove -y mysql-community-client-5.7.16-1.el7.x86_64

实际上，卸载第一个mysql-community-libs和第二个mysql-community-common就可以了，其他也被删除了。执行其他提示如下：

[hadoop@node3 ~]$ sudo yum remove -y mysql-community-libs-compat-5.7.16-1.el7.x86_64
Loaded plugins: fastestmirror
No Match for argument: mysql-community-libs-compat-5.7.16-1.el7.x86_64
No Packages marked for removal
[hadoop@node3 ~]$ sudo yum remove -y mysql-community-server-5.7.16-1.el7.x86_64
Loaded plugins: fastestmirror
No Match for argument: mysql-community-server-5.7.16-1.el7.x86_64
No Packages marked for removal
[hadoop@node3 ~]$ sudo yum remove -y mysql-community-client-5.7.16-1.el7.x86_64
Loaded plugins: fastestmirror
No Match for argument: mysql-community-client-5.7.16-1.el7.x86_64
No Packages marked for removal
[hadoop@node3 ~]$ rpm -qa|grep mysql
​

查询剩余的安装包

[hadoop@node3 ~]$ rpm -qa|grep mysql
[hadoop@node3 ~]$ 

如果还能查到，就执行对应的yum remove命令删除即可。

删除mysql安装包

[hadoop@node3 ~]$ rm -rf installfile/06.Mysql

注意：mysql安装包路径可能不一样，根据实际情况修改。

查找mysql残留文件

[hadoop@node3 ~]$ sudo find / -name mysql
/etc/selinux/targeted/active/modules/100/mysql
/var/lib/mysql
/var/lib/mysql/mysql
/usr/share/mysql
/home/hadoop/soft/hive/scripts/metastore/upgrade/mysql
/home/hadoop/soft/sqoop/src/java/org/apache/sqoop/mapreduce/mysql
/home/hadoop/soft/sqoop/src/test/org/apache/sqoop/manager/mysql
​

显然后面三个是其他应用的mysql，不需要删除，只需要删除mysql本身相关的文件，即前四个文件。

移除mysql残留文件

[hadoop@node3 ~]$ sudo rm -rf /etc/selinux/targeted/active/modules/100/mysql
[hadoop@node3 ~]$ sudo rm -rf /var/lib/mysql
[hadoop@node3 ~]$ sudo rm -rf /var/lib/mysql/mysql
[hadoop@node3 ~]$ sudo rm -rf /usr/share/mysql

删除mysqld.log

[hadoop@node3 ~]$ sudo rm -rf /var/log/mysqld.log

完成！enjoy it!