Uninstalling MySQL database under Linux

Uninstalling MySQL database under Linux

How to uninstall MySQL database under Linux? The following summarizes and organizes the methods of uninstalling MySQL on 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 uninstallation steps are slightly different depending on the installation method. If there are any deficiencies or errors in the article, please point them out or add to them!

Uninstalling MySQL using RPM package installation

1. Check whether 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, the client, server, and devel components of MySQL 5.6.23 are installed.

2. Close 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 the 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 files related to the MySQL database, so that you can completely delete 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 various MySQL components

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

5. Delete the folder corresponding to MySQL

Check whether each MySQL folder has been cleaned up 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 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 or deleted

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

Uninstalling MySQL using binary package or source code installation

If you installed MySQL using a binary package, you will not find any MySQL components using the following command. So if you don't know how to install MySQL, don't 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 the status of the MySQL service through the process. 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 1 0 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]#

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

Reference: Detailed explanation of completely uninstalling MySQL under Linux

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.

You may also be interested in:
  • Completely uninstall MySQL database in Windows system to reinstall MySQL
  • Complete steps for uninstalling MySQL database
  • How to completely uninstall the MySQL database

<<:  How to modify the time in centos virtual machine

>>:  Vue implements countdown function

Recommend

Sample code for implementing multi-application deployment using tomcat+nginx

Table of contents Multi-application deployment 1-...

Full HTML of the upload form with image preview

The upload form with image preview function, the ...

isPrototypeOf Function in JavaScript

Table of contents 1. isPrototypeOf() Example 1, O...

Importance of background color declaration when writing styles

As the title says, otherwise when the page is revi...

Manjaro installation CUDA implementation tutorial analysis

At the end of last year, I replaced the opensuse ...

Detailed explanation of the this pointing problem in JavaScript

Summarize Global environment ➡️ window Normal fun...

Troubleshooting ideas and solutions for high CPU usage in Linux systems

Preface As Linux operation and maintenance engine...

Vue uses three methods to refresh the page

When we are writing projects, we often encounter ...

MySQL log settings and viewing methods

MySQL has the following logs: Error log: -log-err...

Solve the problem that shutting down Tomcat using shutdown.bat will shut down other Tomcats

The shutdown.bat file has a sentence if not "...

How to use async and await in JS

Table of contents 1. async 2. await: 3. Comprehen...

Horizontal header menu implemented with CSS3

Result:Implementation Code html <nav class=&qu...

Detailed explanation of MySql view trigger stored procedure

view: When a temporary table is used repeatedly, ...

The whole process of installing mysql5.7.22 under ARM64 architecture

MySQL download address: https://obs.cn-north-4.my...

Mysql implementation of full-text search and keyword scoring method example

1. Introduction Today a colleague asked me how to...