1.登录数据库,show databases命令查看之前已经创建好的数据库
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mairuan |
| mysql |
| performance_schema |
| sys |
+--------------------+
5 rows in set (0.01 sec)
2.使用drop database db_name删除数据库,如上mairuan是之前已经创建好的数据库,现在删除掉
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
+--------------------+
4 rows in set (0.00 sec)
mysql>
3.whereis 查看mysql安装路径
[root@mair-001 ~]# whereis mysql;
mysql: /usr/bin/mysql /usr/lib64/mysql /usr/share/man/man1/mysql.1.gz
[root@mair-001 ~]#
4.关闭mysql服务(service mysqld stop)
[root@mair-001 ~]# service mysqld stop;
Redirecting to /bin/systemctl stop mysqld.service
[root@mair-001 ~]#
5.查看还安装过mysql相关的rpm包文件(rpm -qa|grep mysql)
[root@mair-001 ~]# rpm -qa | grep mysql;
mysql80-community-release-el7-1.noarch
mysql-community-client-8.0.11-1.el7.x86_64
mysql-community-libs-8.0.11-1.el7.x86_64
mysql-community-server-8.0.11-1.el7.x86_64
mysql-community-common-8.0.11-1.el7.x86_64
mysql-community-libs-compat-8.0.11-1.el7.x86_64
[root@mair-001 ~]#
6.模糊匹配删除掉mysql的安装包的文件(yum remove mysql)
[root@mair-001 ~]# yum remove mysql;
Loaded plugins: fastestmirror
Resolving Dependencies
--> Running transaction check
---> Package mysql-community-client.x86_64 0:8.0.11-1.el7 will be erased
--> Processing Dependency: mysql-community-client(x86-64) >= 8.0.0 for package: mysql-community-server-8.0.11-1.el7.x86_64
..........................
7.继续删除掉rpm包 (yum remove 通过第5步找到的rpm安装包的文件)
[root@mair-001 ~]# rpm -qa | grep mysql;
mysql80-community-release-el7-1.noarch
mysql-community-libs-8.0.11-1.el7.x86_64
mysql-community-common-8.0.11-1.el7.x86_64
mysql-community-libs-compat-8.0.11-1.el7.x86_64
[root@mair-001 ~]# yum remove mysql80-community-release-el7-1.noarch;
[root@mair-001 ~]# yum remove mysql-community-common-8.0.11-1.el7.x86_64;
8.检查rpm包是否已经全部删除,如下已经查询不到rpm包
[root@mair-001 ~]# rpm -qa | grep mysql;
[root@mair-001 ~]#
9.删除mysql服务
[root@mair-001 ~]# chkconfig --list | grep -i mysql
[root@mair-001 ~]# chkconfig --del mysql
10.删除分散mysql文件夹
[root@mair-001 ~]# whereis mysql
mysql: /usr/lib/mysql /usr/share/mysql
11.清空相关mysql的所有目录以及文件
[root@mair-001 ~]#rm -rf /usr/lib/mysql
[root@mair-001 ~]#rm -rf /usr/share/mysql
[root@mair-001 ~]#rm -rf /usr/my.cnf
至此,mysql就已经卸载完了