Shulou(Shulou.com)05/31 Report--

This article mainly explains "what are the methods of uninstalling MySQL". The content of the article is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn "what are the methods of unloading MySQL"?

1) MySQL uninstall of RPM package installation

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

Clip_image001

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]

Clip_image002

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] #

Clip_image003

[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

Clip_image004

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.5

You have new mail in / var/spool/mail/root

[root@DB-Server init.d] # rpm-ev MySQL-client-5.6.23-1.linux_glibc2.5

[root@DB-Server init.d] #

Clip_image005

5: delete the folder corresponding to MySQL

Check that each MySQL folder is cleaned and deleted.

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

Mysql:

[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 mysql

Mysql:x:101:501::/home/mysql:/bin/bash

[root@DB-Server ~] # more / etc/shadow | grep mysql

Mysql:!!:16496:

[root@DB-Server ~] # more / etc/group | grep mysql

Mysql:x:501:

[root@DB-Server ~] # userdel mysql

[root@DB-Server ~] # groupdel mysql

Groupdel: 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

2) 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 mysql

Root 4752 4302 0 22:55 pts/1 00:00:00 more / etc/init.d/mysql.server

Root 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.pid

Mysql 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.pid

Root 7321 4302 0 23:23 pts/1 00:00:00 grep mysql

[root@DB-Server init.d] # / etc/init.d/mysql.server status

MySQL running (7269) [OK]

[root@DB-Server init.d] # / etc/init.d/mysql.server stop

Shutting down MySQL.. [OK]

[root@DB-Server init.d] # / etc/init.d/mysql.server status

MySQL is not running [FAILED]

[root@DB-Server init.d] #

Clip_image006

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

Clip_image007

[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

Thank you for your reading, these are the contents of "what are the methods of unloading MySQL?" after the study of this article, I believe you have a deeper understanding of what the method of unloading MySQL has, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

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.