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

The following content mainly brings you how to uninstall mysql handouts, the knowledge mentioned, different from books, are summed up by professional and technical personnel in the process of contact with users, with a certain value of experience sharing, hoping to bring help to the majority of readers.

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 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] # if the uninstall execution error Then use rpm-e-- nodeps to force uninstall

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.

For the above on how to uninstall mysql handouts, if you need to know more, you can continue to follow our industry promotion, if you need professional answers, you can contact the pre-sales and after-sales on the official website. I hope this article can bring you some knowledge updates.

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.