Shulou(Shulou.com)06/01 Report--

1: check if the MySQL component is installed.

[root@DB-Server init.d] # rpm-qa | grep-I mysql MySQL-devel-5.6.23-1.linux_glibc2.5 MySQL-client-5.6.23-1.linux_glibc2.5 MySQL-server-5.6.23-1.linux_glibc2.5

As shown above, three components of client, server and devel of MySQL 5.6.23 are installed.

2: shut down the MySQL service before uninstalling

2.1 method 1

[root@DB-Server init.d] # service mysql status MySQL running (25673) [OK] [root@DB-Server init.d] # service mysql stop Shutting down MySQL.. [OK] [root@DB-Server init.d] # service mysql status MySQL is not running [FAILED]

2.2 method 2

[root@DB-Server init.d] #. / mysql status MySQL running (26215) [OK] [root@DB-Server init.d] #. / mysql stop Shutting down MySQL.. [OK] [root@DB-Server init.d] #. / mysql status MySQL is not running [FAILED] [root@DB-Server init.d] #

[root@DB-Server init.d] # chkconfig-- list | grep-i mysql mysql 0:off 1:off 2:on 3:on 4:on 5:on 6:off [root@DB-Server init.d] #

3. Collect folder information corresponding to MySQL

[root@DB-Server init.d] # whereis mysql

Mysql: / usr/bin/mysql / usr/include/mysql / usr/share/mysql / usr/share/man/man1/mysql.1.gz

It is best to use the find command to view the files related to the MySQL database to facilitate the complete deletion of MySQL later.

[root@DB-Server init.d] # find /-name mysql/etc/rc.d/init.d/mysql/etc/logrotate.d/mysql/var/lock/subsys/mysql/var/lib/mysql/var/lib/mysql/mysql/usr/include/mysql/usr/include/mysql/mysql/usr/bin/mysql/usr/share/mysql/usr/lib64/mysql

4: uninstall and delete all kinds of components of MySQL

[root@DB-Server init.d] # [root@DB-Server init.d] # rpm-ev MySQL-devel-5.6.23-1.linux _ glibc2.5 [root @ DB-Server init.d] # rpm-ev MySQL-server-5.6.23-1.linux_glibc2.5You have new mail in / var/spool/mail/root [root@DB-Server init.d] # rpm-ev MySQL-client-5.6.23-1.linuxglibc2.5 [root @ DB-Server init.d] #

5: delete the folder corresponding to MySQL

Check that each MySQL folder is cleaned and deleted.

[root@DB-Server init.d] # whereis mysqlmysql: [root@DB-Server init.d] # find /-name mysql/var/lib/mysql/var/lib/mysql/mysql/usr/lib64/mysql [root@DB-Server init.d] # rm-rf / var/lib/mysql [root@DB-Server init.d] # rm-rf / var/lib/mysql/mysql [root@DB-Server init.d] # rm-rf / usr/lib64/mysql [root@DB-Server init.d] #

6: delete mysql users and user groups

If necessary, delete the mysql user and the mysql user group.

[root@DB-Server ~] # more / etc/passwd | grep mysqlmysql:x:101:501::/home/mysql:/bin/bash [root@DB-Server ~] # more / etc/shadow | grep MySQL mysql grep mysqlmysql:x:501 16496: [root@DB-Server ~] # more / etc/group | grep mysqlmysql:x:501: [root@DB-Server ~] # userdel mysql [root@DB-Server ~] # groupdel mysqlgroupdel: group mysql does not exist [root@DB-Server ~] #

7: confirm whether MySQL is uninstalled and deleted

[root@DB-Server init.d] # rpm-qa | grep-I mysql

MySQL uninstall of binary package / source code installation

If you installed MySQL in a binary package, you won't find any MySQL components with the following command. So if you don't know how to install MySQL, do not use the following command to determine whether MySQL is installed.

[root@DB-Server init.d] # rpm-qa | grep-I mysql

1: check the MySQL service and shut down the service process.

First, check through the process to see if there is a status of the MySQL service, as shown below, the MySQL service is started.

[root@DB-Server init.d] # ps-ef | grep mysqlroot 4752 4302 0 22:55 pts/1 00:00:00 more / etc/init.d/mysql.serverroot 7176 10 23:23 pts/1 00:00:00 / bin/sh / usr/local/mysql/bin/mysqld_safe-- datadir=/usr/local/mysql/data-- pid-file=/usr/local/mysql/data/DB-Server.localdomain.pidmysql 7269 7176 15 23:23 Pts/1 00:00:01 / usr/local/mysql/bin/mysqld-basedir=/usr/local/mysql-datadir=/usr/local/mysql/data-plugin-dir=/usr/local/mysql/lib/plugin-user=mysql-log-error=/usr/local/mysql/data/DB-Server.localdomain.err-pid-file=/usr/local/mysql/data/DB-Server.localdomain.pidroot 7321 4302 0 23:23 pts/1 00:00:00 grep mysql [root @ DB-Server init.d] # / etc/init.d/mysql.server statusMySQL running (7269) [OK] [root@DB-Server init.d] # / etc/init.d/mysql.server stopShutting down MySQL.. [OK] [root@DB-Server init.d] # / etc/init.d/mysql.server statusMySQL is not running [FAILED] [root@DB-Server init.d] #

2: find the installation directory of MySQL and delete it completely

[root@DB-Server init.d] # whereis mysql mysql: / usr/local/mysql [root@DB-Server init.d] # find /-name mysql / var/spool/mail/mysql / usr/local/mysql-5.7.5-m15-linux-glibc2.5-x86_64/include/mysql / usr/local/mysql-5.7.5-m15-linux-glibc2.5-x86_64/bin/mysql / usr/local/mysql-5.7.5-m15-linux- Glibc2.5-x86_64/data/mysql / usr/local/mysql

[root@DB-Server init.d] # rm-rf / usr/local/mysql-5.7.5-m15-linux-glibc2.5-x86_64/ [root@DB-Server init.d] # rm-rf / usr/local/ [root@DB-Server init.d] # rm-rf / var/spool/mail/mysql [root@DB-Server init.d] #

3: delete some configuration files

The configuration file usually has / etc/my.cnf or / etc/init.d/mysql.server, depending on the installation configuration.

4: delete MySQL users and user groups

[root@DB-Server ~] # id mysql uid=101 (mysql) gid=501 (mysql) groups=501 (mysql) context=root:system_r:unconfined_t:SystemLow-SystemHigh [root@DB-Server ~] # userdel mysql

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.