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

This article is about how to uninstall MySQL database under Linux. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

This article mainly introduces the method of uninstalling MySQL database under Linux. I don't know that friends who uninstall MySQL database under Linux can learn about it. This article has a certain reference value and hopes to help you.

How to uninstall the MySQL database under Linux? The following summarizes and sorts out the methods to uninstall MySQL under the Linux platform. There are three main ways to install MySQL: binary package installation (Using Generic Binaries), RPM package installation, and source code installation. The uninstall steps are somewhat different for different installation methods. If there are any inadequacies or errors in the article, please point out or add!

MySQL uninstall of RPM package installation

1. Check whether the MySQL component is installed.

[root@DB-Server init.d] # rpm-qa | grep-I mysqlMySQL-devel-5.6.23-1.linux_glibc2.5MySQL-client-5.6.23-1.linuxroomglibc2.5MySQL-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. Disable 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]

Undefined

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 mysqlmysql 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

Undefined

4. Uninstall and delete various 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 close 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.

Undefined

[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

Undefined

[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. Configuration files are generally / etc/my.cnf or / etc/init.d/mysql.server, depending on the specific installation and 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

Reference: complete uninstall of mysql under Linux

Related recommendations:

Complete steps to uninstall the MySQL database (figure)

Mysql Advanced (XVIII) complete uninstall of mysql Database Picture and text tutorial

What projects are required to uninstall the implementation of the MySQL database?

Thank you for reading! This is the end of this article on "how to uninstall MySQL database under Linux". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it out for more people to see!

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.