Centos installs MysqlServer and MysqlWorkbench

centos system

First, delete mysql from centos system

The reason for deletion is that it does not fit
Version 8.0.24 of MysqlCommunity and MysqlWorkbench are installed
Step 1
First check whether the system comes with Mysql

[dalaojun@localhost download]$ whereis mysql
mysql: /usr/bin/mysql /usr/lib64/mysql /usr/include/mysql /usr/share/mysql /usr/share/man/man1/mysql.1.gz

View the built-in version number

[dalaojun@localhost download]$ mysql -V
mysql  Ver 15.1 Distrib 5.5.68-MariaDB, for Linux (x86_64) using readline 5.1
[dalaojun@localhost download]$ 

Step 2
Check whether mysql is currently running

see MySQL Service status
service mysqld status
 suspend MySQL service
service mysqld stop

Close the mysql service before uninstalling

View mysql installation package
Check whether mysql installed in rpm package is available in the system

rpm -qa|grep -i mysql

Uninstall after closing mysql service
sudo rpm -ev --nodeps
-e uninstall the software in the system
-v detail the installation process
– nodeps means that dependencies are not checked during installation
– force forced installation

[dalaojun@localhost mysql]$ rpm -qa|grep -i mysql
[dalaojun@localhost mysql]$ sudo rpm -ev --nodeps perl-DBD-MySQL-4.023-6.el7.x86_64
 Package preparation in progress...
[dalaojun@localhost mysql]$ sudo rpm -ev --nodeps MySQL-python-1.2.5-1.el7.x86_64
 Package preparation in progress...
[dalaojun@localhost mysql]$ sudo rpm -ev --nodeps qt3-MySQL-3.3.8b-51.el7.x86_64
 Package preparation in progress...
[dalaojun@localhost mysql]$ rpm -qa|grep -i mysql
[dalaojun@localhost mysql]$ 

Step 3
Uninstall MariaDB
sudo yum remove mariadb

You need root Permission to execute this command.
[dalaojun@localhost download]$ sudo yum remove mariadb mariadb-server
[sudo] dalaojun Password for:
Plug in loaded: fastestmirror, langpacks
 Resolving dependencies
--> Checking transactions
---> software package mariadb.x86_64. Will be deleted
---> software package mariadb-server.x86_64. Will be deleted
--> Processing dependencies mariadb-server,It is a software package akonadi-mysql-1.9.2-4.el7.x86_64 need
--> Checking transactions
---> software package akonadi-mysql.x86_64. Will be deleted
--> Resolve dependency complete
base/7/x86_64                                            | 3.6 kB     00:00     
copr:copr.fedorainfracloud.org:librehat:shadowsocks/x86_ | 3.3 kB     00:00     
epel/x86_64                                              | 4.7 kB     00:00     
epel/x86_64/updateinfo                                   | 1.0 MB     00:00     
epel/x86_64/primary_db                                   | 6.9 MB     00:02     
extras/7/x86_64                                          | 2.9 kB     00:00     
google-chrome                                            | 1.3 kB     00:00     
nux-dextop/x86_64                                        | 2.9 kB     00:00     
teamviewer/x86_64/signature                              |  867 B     00:00     
teamviewer/x86_64/signature                              | 2.5 kB     00:00 !!! 
updates/7/x86_64                                         | 2.9 kB     00:00     

Dependency resolution

 Package              framework         edition                   source               size
 mariadb              x86_64       1:5.5.68-1.el7         @base            49 M
 mariadb-server       x86_64       1:5.5.68-1.el7         @base            58 M
 Remove for dependency:
 akonadi-mysql        x86_64       1.9.2-4.el7            @anaconda       9.6 k

Transaction summary
Remove 2 packages (+1 Dependent packages)

Installation size: 107 M
 Continue?[y/N]: y
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
 Warning: RPM The database has been deleted yum Program modification.
  Deleting    : akonadi-mysql-1.9.2-4.el7.x86_64                            1/3 
  Deleting    : 1:mariadb-server-5.5.68-1.el7.x86_64                        2/3 
  Deleting    : 1:mariadb-5.5.68-1.el7.x86_64                               3/3 
  Verification in progress      : 1:mariadb-server-5.5.68-1.el7.x86_64                        1/3 
  Verification in progress      : akonadi-mysql-1.9.2-4.el7.x86_64                            2/3 
  Verification in progress      : 1:mariadb-5.5.68-1.el7.x86_64                               3/3 

  mariadb.x86_64 1:5.5.68-1.el7       mariadb-server.x86_64 1:5.5.68-1.el7      

Deleted as dependency:
  akonadi-mysql.x86_64 0:1.9.2-4.el7                                            


Step 4
Delete relevant software

[dalaojun@localhost etc]$ rpm -qa|grep mysql
[dalaojun@localhost etc]$ 
[dalaojun@localhost etc]$ sudo rpm -e --nodeps qt5-qtbase-mysql-5.9.7-5.el7_9.x86_64
[dalaojun@localhost etc]$ sudo rpm -e --nodeps qt-mysql-4.8.7-9.el7_9.x86_64
[dalaojun@localhost etc]$ 

Delete relevant software

[dalaojun@localhost etc]$ rpm -qa | grep mariadb
[dalaojun@localhost etc]$ sudo rpm -e --nodeps mariadb-libs-5.5.68-1.el7.x86_64
[sudo] dalaojun Password for:
[dalaojun@localhost etc]$ sudo rpm -e --nodeps mariadb-devel-5.5.68-1.el7.x86_64
[dalaojun@localhost etc]$ 

View the command comments of the corresponding mysql files and software

-qa: Find the corresponding file, such as rpm -qa mysql
rpm -q mysql list mysql Installation information for
rpm -qa|grep mysql Yes list contains mysql Field of the software.
stop it mysql Services, remove previously installed mysql
 Delete command: rpm -e –nodeps <Package name>

Step 5
View the mysql file directory and delete the file directory

[dalaojun@localhost etc]$ whereis mysql
mysql: /usr/lib64/mysql /usr/include/mysql /usr/share/mysql
[dalaojun@localhost etc]$rm -rf /usr/lib64/mysql
[dalaojun@localhost etc]$rm -rf /usr/include/mysql
[dalaojun@localhost etc]$rm -rf /usr/share/mysql

Use the command rm -rf xxx to delete the above files in sequence

Step 6
Check whether the relevant files exist again

[dalaojun@localhost etc]$ whereis mysql
[dalaojun@localhost etc]
[dalaojun@localhost etc]$ rpm -qa|grep mysql
[dalaojun@localhost etc]$ rpm -qa|grep mariadb
[dalaojun@localhost etc]$ 

If there is any, delete it again
Step 7
After uninstalling mysql, / etc / my CNF will not be deleted and needs to be deleted manually
rm /etc/my.cnf

Mysql official website

Enter the MysqlCommunity and MysqlWorkbench download page
Choose to download a stable version

The first installation method is tar package installation

(the second method is recommended)

Select the below, thank you, download directly
No thanks, just start my download.
I downloaded MysqlCommunityServer, which is a tar package

If your is CentOS 8, it's the following one


(if you don't have tar on your computer, the decompression software installation command of tar is yum install -y tar)
If your bag is tar The end of XZ needs to be decompressed once in advance

xz -d mysql-8.0.24-1.el8.x86_64.rpm-bundle.tar.xz

Create a mysql folder in the location of the current package

mkdir mysql

mysql-8.0.24-1 el8. x86_ 64.rpm-bundle. Move tar to mysql folder

mv mysql-8.0.24-1.el8.x86_64.rpm-bundle.tar /mysql

Enter mysql folder

cd mysql

tar package decompression

sudo tar -xvf mysql-8.0.24-1.el8.x86_64.rpm-bundle.tar

Move the mysql folder to / usr/local /
Return to the previous level

cd ..


sudo mv mysql /usr/local/mysql

If you make an installation error, browse to the bottom of this article
Branch 1: install using python script

#If your downloaded package is 8.0.24-1, copy this code directly and save it to XXX Py file execution
import os

#Synchronization, one by one, has been sorted
list=["sudo rpm -ivh /usr/local/mysql/mysql-community-common-8.0.24-1.el8.x86_64.rpm",
    "sudo rpm -ivh /usr/local/mysql/mysql-community-client-8.0.24-1.el8.x86_64.rpm",
    "sudo rpm -ivh /usr/local/mysql/mysql-community-libs-8.0.24-1.el8.x86_64.rpm",
    "sudo rpm -ivh /usr/local/mysql/mysql-community-server-8.0.24-1.el8.x86_64.rpm"]
for i in list:

Branch 2:
Manual installation

sudo rpm -ivh /usr/local/mysql/mysql-community-common-8.0.24-1.el8.x86_64.rpm
sudo rpm -ivh /usr/local/mysql/mysql-community-client-8.0.24-1.el8.x86_64.rpm
sudo rpm -ivh /usr/local/mysql/mysql-community-libs-8.0.24-1.el8.x86_64.rpm
sudo rpm -ivh /usr/local/mysql/mysql-community-server-8.0.24-1.el8.x86_64.rpm

Second installation method

Use the yum command to install

mysql yum command download page

After downloading, it is also placed in the usr/local/mysql directory [in fact, there is no need to have a party here, because this package is only a path package and has no impact on the installation. Using this method, the installation system will automatically install it to the default location, which can be found by using whereis mysql]
The following commands are installed for CentOS 7

sudo rpm -ivh mysql80-community-release-el7-1.noarch.rpm

Then the installation is prompted below


Warning: RPM The database has been deleted yum Program modification.
** Found 6 existing RPM Database problems, 'yum check' The output is as follows:
1:net-snmp-5.7.2-49.el7_9.1.x86_64 There is a lack of demand libmysqlclient.so.18()(64bit)
1:net-snmp-5.7.2-49.el7_9.1.x86_64 There is a lack of demand mysql-libs
1:net-snmp-agent-libs-5.7.2-49.el7_9.1.x86_64 There is a lack of demand libmysqlclient.so.18()(64bit)
1:net-snmp-agent-libs-5.7.2-49.el7_9.1.x86_64 There is a lack of demand libmysqlclient.so.18(libmysqlclient_18)(64bit)
2:postfix-2.10.1-9.el7.x86_64 There is a lack of demand libmysqlclient.so.18()(64bit)
2:postfix-2.10.1-9.el7.x86_64 There is a lack of demand libmysqlclient.so.18(libmysqlclient_18)(64bit)
  Installing    : mysql80-community-release-el7-3.noarch                      1/1 
  Verification in progress      : mysql80-community-release-el7-3.noarch                      1/1 

already installed:
  mysql80-community-release.noarch 0:el7-3                                      



yum clean all

yum Will download the software package and header store in cache Without automatic deletion. Occupy disk space, can use yum clean Command to clear. The more precise usage is yum clean headers eliminate header,yum clean packages Clear downloaded rpm Bag, yum clean all I. clear all

Re execution

yum makecache
yum makecache Yes, the package information on the server is now cached locally,To improve the speed of searching and installing software
[dalaojun@localhost mysql]$ yum clean all
 Plug in loaded: fastestmirror, langpacks
 Cleaning up software source: base copr:copr.fedorainfracloud.org:librehat:shadowsocks epel
               : extras google-chrome mysql-connectors-community
               : mysql-tools-community mysql80-community nux-dextop teamviewer
               : updates
Other repos take up 2.9 G of disk space (use --verbose for details)
[dalaojun@localhost mysql]$ yum makecache

Then the system will quickly load the installation package
Plug in required for upgrading computer system
Because mariadb and mysql and some plug-ins were deleted before
Wait until the metadata cache has been established
Execute mysqlserver installation

sudo yum install mysql-community-server

Wait 1 minute and the installation is completed.

Mysql official website
MySQL workbench installation
centos7.9 system, in rpm format, the latest version is 8.0.22
The of windows is exe
Here is the file name


After downloading, open the terminal at the download location of the software
The installation command is:

sudo rpm -ivh mysql-workbench-community-8.0.22-1.el7.x86_64.rpm 

After installation, the shortcut key of the software is
use/share/applications directory

The next chapter explains the design of creating database and building database model, as well as connecting database

Keywords: Linux

Added by geekette on Sat, 19 Feb 2022 02:06:36 +0200