下载Mysql安装包地址
https://dev.mysql.com/downloads/mysql/
解压到指定目录
[root@localhost tools]# tar -xvf mysql-8.4.2-1.el7.x86_64.rpm-bundle.tar -C /root/training
[root@localhost tools]# cd ../training/
[root@localhost training]# ll
total 1027204
-rw-r--r--. 1 7155 31415 15319032 Jul 14 01:28 mysql-community-client-8.4.2-1.el7.x86_64.rpm
-rw-r--r--. 1 7155 31415 3624740 Jul 14 01:28 mysql-community-client-plugins-8.4.2-1.el7.x86_64.rpm
-rw-r--r--. 1 7155 31415 706412 Jul 14 01:28 mysql-community-common-8.4.2-1.el7.x86_64.rpm
-rw-r--r--. 1 7155 31415 568523520 Jul 14 01:28 mysql-community-debuginfo-8.4.2-1.el7.x86_64.rpm
-rw-r--r--. 1 7155 31415 2022564 Jul 14 01:28 mysql-community-devel-8.4.2-1.el7.x86_64.rpm
-rw-r--r--. 1 7155 31415 4218836 Jul 14 01:28 mysql-community-embedded-compat-8.4.2-1.el7.x86_64.rpm
-rw-r--r--. 1 7155 31415 2346040 Jul 14 01:28 mysql-community-icu-data-files-8.4.2-1.el7.x86_64.rpm
-rw-r--r--. 1 7155 31415 1591504 Jul 14 01:28 mysql-community-libs-8.4.2-1.el7.x86_64.rpm
-rw-r--r--. 1 7155 31415 686992 Jul 14 01:28 mysql-community-libs-compat-8.4.2-1.el7.x86_64.rpm
-rw-r--r--. 1 7155 31415 63806756 Jul 14 01:29 mysql-community-server-8.4.2-1.el7.x86_64.rpm
-rw-r--r--. 1 7155 31415 26397236 Jul 14 01:29 mysql-community-server-debug-8.4.2-1.el7.x86_64.rpm
-rw-r--r--. 1 7155 31415 362599652 Jul 14 01:30 mysql-community-test-8.4.2-1.el7.x86_64.rpm
检查原先系统是否安装mysql
- 检查原先系统是否安装mysql
rpm -qa |grep -i mysql
- 安装了的话,卸载安装包
yum remove mysql-community-libs-8.0.13-1.el7.x86_64 mysql-community-server-8.0.13-1.el7.x86_64
- 删除MySQL相关的目录
find /* -name mysql rm -rf /usr/bin/mysql rm -rf /usr/lib64/mysql rm -rf /usr/share/mysql rm -rf /var/lib/selinux/targeted/active/modules/200/mysql rm -rf /var/lib/mysql rm -rf /var/log/mysql
- 删除配置文件与日志
rm -rf /etc/my.cnf rm -rf /var/log/mysql/mysqld.log
安装前置(有网centos下载rpm安装包)
1.下载net-tools rpm安装包并安装
[root@localhost training]# mkdir net-tools
[root@localhost training]# cd net-tools/
[root@localhost net-tools]# yum install net-tools --downloadonly --downloaddir=/root/training/net-tools/
[root@localhost net-tools]# ls
net-tools-2.0-0.25.20131004git.el7.x86_64.rpm
#安装
[root@localhost net-tools]# rpm -ivh net-tools-2.0-0.25.20131004git.el7.x86_64.rpm
warning: net-tools-2.0-0.25.20131004git.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID f4a80eb5: NOKEY
Preparing... ################################# [100%]
Updating / installing...1:net-tools-2.0-0.25.20131004git.el################################# [100%]
2.下载perl相关包
[root@localhost training]# mkdir perl
[root@localhost training]# cd perl/
[root@localhost perl]# yum install perl --downloadonly --downloaddir=/root/training/perl/
[root@localhost perl]# ll
total 11708
-rw-r--r--. 1 root root 8360316 Feb 4 2021 perl-5.16.3-299.el7_9.x86_64.rpm
-rw-r--r--. 1 root root 19672 Jul 4 2014 perl-Carp-1.26-244.el7.noarch.rpm
-rw-r--r--. 1 root root 19244 Jul 4 2014 perl-constant-1.27-2.el7.noarch.rpm
-rw-r--r--. 1 root root 1545440 Jul 4 2014 perl-Encode-2.51-7.el7.x86_64.rpm
-rw-r--r--. 1 root root 29092 Jul 4 2014 perl-Exporter-5.68-3.el7.noarch.rpm
-rw-r--r--. 1 root root 27088 Jul 4 2014 perl-File-Path-2.09-2.el7.noarch.rpm
-rw-r--r--. 1 root root 57680 Jul 4 2014 perl-File-Temp-0.23.01-3.el7.noarch.rpm
-rw-r--r--. 1 root root 78236 Jul 4 2014 perl-Filter-1.49-3.el7.x86_64.rpm
-rw-r--r--. 1 root root 57176 Apr 25 2018 perl-Getopt-Long-2.40-3.el7.noarch.rpm
-rw-r--r--. 1 root root 39292 Jul 4 2014 perl-HTTP-Tiny-0.033-3.el7.noarch.rpm
-rw-r--r--. 1 root root 706128 Feb 4 2021 perl-libs-5.16.3-299.el7_9.x86_64.rpm
-rw-r--r--. 1 root root 45324 Feb 4 2021 perl-macros-5.16.3-299.el7_9.x86_64.rpm
-rw-r--r--. 1 root root 12592 Jul 4 2014 perl-parent-0.225-244.el7.noarch.rpm
-rw-r--r--. 1 root root 84468 Jul 4 2014 perl-PathTools-3.40-5.el7.x86_64.rpm
-rw-r--r--. 1 root root 53064 Feb 4 2021 perl-Pod-Escapes-1.04-299.el7_9.noarch.rpm
-rw-r--r--. 1 root root 114320 Jul 4 2014 perl-podlators-2.5.1-3.el7.noarch.rpm
-rw-r--r--. 1 root root 88756 Jul 4 2014 perl-Pod-Perldoc-3.20-4.el7.noarch.rpm
-rw-r--r--. 1 root root 221216 Jul 4 2014 perl-Pod-Simple-3.28-4.el7.noarch.rpm
-rw-r--r--. 1 root root 27436 Jul 4 2014 perl-Pod-Usage-1.63-3.el7.noarch.rpm
-rw-r--r--. 1 root root 36808 Jul 4 2014 perl-Scalar-List-Utils-1.27-248.el7.x86_64.rpm
-rw-r--r--. 1 root root 49868 Apr 4 2020 perl-Socket-2.010-5.el7.x86_64.rpm
-rw-r--r--. 1 root root 78888 Jul 4 2014 perl-Storable-2.45-3.el7.x86_64.rpm
-rw-r--r--. 1 root root 14056 Jul 4 2014 perl-Text-ParseWords-3.29-4.el7.noarch.rpm
-rw-r--r--. 1 root root 50392 Jul 4 2014 perl-threads-1.87-4.el7.x86_64.rpm
-rw-r--r--. 1 root root 39868 Jul 4 2014 perl-threads-shared-1.43-6.el7.x86_64.rpm
-rw-r--r--. 1 root root 46304 Jul 4 2014 perl-Time-HiRes-1.9725-3.el7.x86_64.rpm
-rw-r--r--. 1 root root 24792 Jul 4 2014 perl-Time-Local-1.2300-2.el7.noarch.rpm
3.下载 perl-Module-Install.noarch相关包
[root@localhost training]# mkdir perl-Module-Install.noarch
[root@localhost training]# yum install perl-Module-Install.noarch --downloadonly --downloaddir=/root/training/perl-Module-Install.noarch/
[root@localhost perl-Module-Install.noarch]# ls
gdbm-devel-1.10-8.el7.x86_64.rpm perl-IO-Socket-SSL-1.94-7.el7.noarch.rpm
glibc-2.17-326.el7_9.3.x86_64.rpm perl-IPC-Cmd-0.80-4.el7.noarch.rpm
glibc-common-2.17-326.el7_9.3.x86_64.rpm perl-JSON-PP-2.27202-2.el7.noarch.rpm
glibc-devel-2.17-326.el7_9.3.x86_64.rpm perl-libs-5.16.3-299.el7_9.x86_64.rpm
glibc-headers-2.17-326.el7_9.3.x86_64.rpm perl-libwww-perl-6.05-2.el7.noarch.rpm
kernel-headers-3.10.0-1160.119.1.el7.x86_64.rpm perl-Locale-Maketext-1.23-3.el7.noarch.rpm
libdb-5.3.21-25.el7.x86_64.rpm perl-Locale-Maketext-Simple-0.21-299.el7_9.noarch.rpm
libdb-devel-5.3.21-25.el7.x86_64.rpm perl-local-lib-1.008010-4.el7.noarch.rpm
libdb-utils-5.3.21-25.el7.x86_64.rpm perl-Log-Message-0.08-3.el7.noarch.rpm
mailcap-2.1.41-2.el7.noarch.rpm perl-Log-Message-Simple-0.10-2.el7.noarch.rpm
perl-5.16.3-299.el7_9.x86_64.rpm perl-LWP-MediaTypes-6.02-2.el7.noarch.rpm
perl-Algorithm-Diff-1.1902-17.el7.noarch.rpm perl-macros-5.16.3-299.el7_9.x86_64.rpm
perl-Archive-Extract-0.68-3.el7.noarch.rpm perl-Module-Build-0.40.05-2.el7.noarch.rpm
perl-Archive-Zip-1.30-11.el7.noarch.rpm perl-Module-CoreList-2.76.02-299.el7_9.noarch.rpm
perl-Business-ISBN-2.06-2.el7.noarch.rpm perl-Module-Install-1.06-4.el7.noarch.rpm
perl-Business-ISBN-Data-20120719.001-2.el7.noarch.rpm perl-Module-Load-0.24-3.el7.noarch.rpm
perl-Carp-1.26-244.el7.noarch.rpm perl-Module-Load-Conditional-0.54-3.el7.noarch.rpm
perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64.rpm perl-Module-Loaded-0.08-299.el7_9.noarch.rpm
perl-Compress-Raw-Zlib-2.061-4.el7.x86_64.rpm perl-Module-Metadata-1.000018-2.el7.noarch.rpm
perl-constant-1.27-2.el7.noarch.rpm perl-Module-Pluggable-4.8-3.el7.noarch.rpm
perl-CPAN-1.9800-299.el7_9.noarch.rpm perl-Module-ScanDeps-1.10-3.el7.noarch.rpm
perl-CPAN-Meta-2.120921-5.el7.noarch.rpm perl-Module-Signature-0.73-2.el7.noarch.rpm
perl-CPAN-Meta-Requirements-2.122-7.el7.noarch.rpm perl-Mozilla-CA-20130114-5.el7.noarch.rpm
perl-CPAN-Meta-YAML-0.008-14.el7.noarch.rpm perl-Net-Daemon-0.48-5.el7.noarch.rpm
perl-CPANPLUS-0.91.38-4.el7.noarch.rpm perl-Net-HTTP-6.06-2.el7.noarch.rpm
perl-Data-Dumper-2.145-3.el7.x86_64.rpm perl-Net-LibIDN-0.12-15.el7.x86_64.rpm
perl-DBD-SQLite-1.39-3.el7.x86_64.rpm perl-Net-SSLeay-1.55-6.el7.x86_64.rpm
perl-DBI-1.627-4.el7.x86_64.rpm perl-Object-Accessor-0.42-299.el7_9.noarch.rpm
perl-DBIx-Simple-1.35-7.el7.noarch.rpm perl-Package-Constants-0.02-299.el7_9.noarch.rpm
perl-devel-5.16.3-299.el7_9.x86_64.rpm perl-Params-Check-0.38-2.el7.noarch.rpm
perl-Digest-1.17-245.el7.noarch.rpm perl-PAR-Dist-0.49-2.el7.noarch.rpm
perl-Digest-MD5-2.52-3.el7.x86_64.rpm perl-parent-0.225-244.el7.noarch.rpm
perl-Digest-SHA1-2.13-9.el7.x86_64.rpm perl-Parse-CPAN-Meta-1.4404-5.el7.noarch.rpm
perl-Digest-SHA-5.85-4.el7.x86_64.rpm perl-PathTools-3.40-5.el7.x86_64.rpm
perl-Encode-2.51-7.el7.x86_64.rpm perl-Perl-OSType-1.003-3.el7.noarch.rpm
perl-Encode-Locale-1.03-5.el7.noarch.rpm perl-PlRPC-0.2020-14.el7.noarch.rpm
perl-Exporter-5.68-3.el7.noarch.rpm perl-Pod-Escapes-1.04-299.el7_9.noarch.rpm
perl-ExtUtils-CBuilder-0.28.2.6-299.el7_9.noarch.rpm perl-podlators-2.5.1-3.el7.noarch.rpm
perl-ExtUtils-Install-1.58-299.el7_9.noarch.rpm perl-Pod-Perldoc-3.20-4.el7.noarch.rpm
perl-ExtUtils-MakeMaker-6.68-3.el7.noarch.rpm perl-Pod-Simple-3.28-4.el7.noarch.rpm
perl-ExtUtils-Manifest-1.61-244.el7.noarch.rpm perl-Pod-Usage-1.63-3.el7.noarch.rpm
perl-ExtUtils-ParseXS-3.18-3.el7.noarch.rpm perl-Scalar-List-Utils-1.27-248.el7.x86_64.rpm
perl-File-Fetch-0.42-2.el7.noarch.rpm perl-Socket-2.010-5.el7.x86_64.rpm
perl-File-Listing-6.04-7.el7.noarch.rpm perl-Storable-2.45-3.el7.x86_64.rpm
perl-File-Path-2.09-2.el7.noarch.rpm perl-Term-UI-0.36-2.el7.noarch.rpm
perl-File-Remove-1.52-6.el7.noarch.rpm perl-Test-Harness-3.28-3.el7.noarch.rpm
perl-File-Temp-0.23.01-3.el7.noarch.rpm perl-Text-Diff-1.41-5.el7.noarch.rpm
perl-Filter-1.49-3.el7.x86_64.rpm perl-Text-ParseWords-3.29-4.el7.noarch.rpm
perl-Getopt-Long-2.40-3.el7.noarch.rpm perl-threads-1.87-4.el7.x86_64.rpm
perl-HTML-Parser-3.71-4.el7.x86_64.rpm perl-threads-shared-1.43-6.el7.x86_64.rpm
perl-HTML-Tagset-3.20-15.el7.noarch.rpm perl-TimeDate-2.30-2.el7.noarch.rpm
perl-HTTP-Cookies-6.01-5.el7.noarch.rpm perl-Time-HiRes-1.9725-3.el7.x86_64.rpm
perl-HTTP-Daemon-6.01-8.el7.noarch.rpm perl-Time-Local-1.2300-2.el7.noarch.rpm
perl-HTTP-Date-6.02-8.el7.noarch.rpm perl-URI-1.60-9.el7.noarch.rpm
perl-HTTP-Message-6.06-6.el7.noarch.rpm perl-version-0.99.07-6.el7.x86_64.rpm
perl-HTTP-Negotiate-6.01-5.el7.noarch.rpm perl-WWW-RobotRules-6.02-5.el7.noarch.rpm
perl-HTTP-Tiny-0.033-3.el7.noarch.rpm perl-YAML-Tiny-1.51-6.el7.noarch.rpm
perl-IO-Compress-2.061-2.el7.noarch.rpm pyparsing-1.5.6-9.el7.noarch.rpm
perl-IO-HTML-1.00-2.el7.noarch.rpm systemtap-sdt-devel-4.0-13.el7.x86_64.rpm
安装
-
安装erl-Module-Install.noarch相关安装包
[root@localhost training]# cd perl-Module-Install.noarch/ [root@localhost perl-Module-Install.noarch]# rpm -ivh --force --nodeps *.rpm warning: gdbm-devel-1.10-8.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID f4a80eb5: NOKEY Preparing... ################################# [100%] Updating / installing... ..............................119:libdb-utils-5.3.21-25.el7 ################################# [100%]
-
安装prel相关安装包
[root@localhost perl]# rpm -ivh --force --nodeps *.rpm warning: perl-5.16.3-299.el7_9.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID f4a80eb5: NOKEY Preparing... ################################# [100%] Updating / installing...1:perl-parent-1:0.225-244.el7 ################################# [ 4%]2:perl-HTTP-Tiny-0.033-3.el7 ################################# [ 7%].............................26:perl-Time-Local-1.2300-2.el7 ################################# [ 96%]27:perl-4:5.16.3-299.el7_9 ################################# [100%]
-
安装 mysql-community-client-plugins-8.4.2-1.el7.x86_64.rpm
[root@localhost training]# rpm -ivh mysql-community-client-plugins-8.4.2-1.el7.x86_64.rpm warning: mysql-community-client-plugins-8.4.2-1.el7.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID a8d3785c: N OKEY Preparing... ################################# [100%] Updating / installing...1:mysql-community-client-plugins-8.################################# [100%]
-
安装 mysql-community-icu-data-files-8.4.2-1.el7.x86_64.rpm
[root@localhost training]# rpm -ivh mysql-community-icu-data-files-8.4.2-1.el7.x86_64.rpm warning: mysql-community-icu-data-files-8.4.2-1.el7.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID a8d3785c: N OKEY Preparing... ################################# [100%] Updating / installing...1:mysql-community-icu-data-files-8.################################# [100%]
-
安装 mysql-community-common-8.4.2-1.el7.x86_64.rpm
[root@localhost training]# rpm -ivh mysql-community-common-8.4.2-1.el7.x86_64.rpm warning: mysql-community-common-8.4.2-1.el7.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID a8d3785c: NOKEY Preparing... ################################# [100%] Updating / installing...1:mysql-community-common-8.4.2-1.el################################# [100%]
-
安装 mysql-community-embedded-compat-8.3.0-1.el7.x86_64.rpm
[root@localhost training]# rpm -ivh mysql-community-embedded-compat-8.4.2-1.el7.x86_64.rpm ....... 6_64 conflicts with file from package mariadb-libs-1:5.5.60-1.el7_5.x86_64file /usr/share/mysql/charsets/swe7.xml from install of mysql-community-embedded-compat-8.4.2-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.60-1.el7_5.x86_64
-
安装 mysql-community-libs-8.3.0-1.el7.x86_64.rpm
[root@localhost training]# rpm -ivh mysql-community-libs-8.4.2-1.el7.x86_64.rpm warning: mysql-community-libs-8.4.2-1.el7.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID a8d3785c: NOKEY error: Failed dependencies:mariadb-libs is obsoleted by mysql-community-libs-8.4.2-1.el7.x86_6#错误描述:则是由于centos7默认安装的mariaDB导致 [root@localhost training]# rpm -qa| grep mari mariadb-libs-5.5.60-1.el7_5.x86_64 #强制卸载 rpm -e --nodeps mariadb-libs-5.5.60-1.el7_5.x86_64 #再次安装 [root@localhost training]# rpm -ivh mysql-community-libs-8.4.2-1.el7.x86_64.rpm warning: mysql-community-libs-8.4.2-1.el7.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID a8d3785c: NOKEY Preparing... ################################# [100%] Updating / installing...1:mysql-community-libs-8.4.2-1.el7 ################################# [100%]
-
装 mysql-community-client-8.3.0-1.el7.x86_64.rpm
[root@localhost training]# rpm -ivh mysql-community-client-8.4.2-1.el7.x86_64.rpm warning: mysql-community-client-8.4.2-1.el7.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID a8d3785c: NOKEY Preparing... ################################# [100%] Updating / installing...1:mysql-community-client-8.4.2-1.el################################# [100%]
-
安装 mysql-community-server-8.3.0-1.el7.x86_64.rpm
[root@localhost training]# rpm -ivh mysql-community-server-8.4.2-1.el7.x86_64.rpm warning: mysql-community-server-8.4.2-1.el7.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID a8d3785c: NOKEY Preparing... ################################# [100%] Updating / installing...1:mysql-community-server-8.4.2-1.el################################# [100%] #安装出现以下错误缺失1 2 步骤依赖包 [root@localhost training]# rpm -ivh mysql-community-server-8.4.2-1.el7.x86_64.rpm warning: mysql-community-server-8.4.2-1.el7.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID a8d3785c: NOKEY error: Failed dependencies:/usr/bin/perl is needed by mysql-community-server-8.4.2-1.el7.x86_64net-tools is needed by mysql-community-server-8.4.2-1.el7.x86_64perl(Getopt::Long) is needed by mysql-community-server-8.4.2-1.el7.x86_64perl(strict) is needed by mysql-community-server-8.4.2-1.el7.x86_64
启动mysql
[root@localhost network-scripts]# systemctl start mysqld #启动mysql
[root@localhost network-scripts]# systemctl status mysqld
● mysqld.service - MySQL ServerLoaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)Active: active (running) since Sun 2024-09-22 18:11:03 CST; 5s agoDocs: man:mysqld(8)http://dev.mysql.com/doc/refman/en/using-systemd.htmlProcess: 20010 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)Main PID: 20079 (mysqld)Status: "Server is operational"CGroup: /system.slice/mysqld.service└─20079 /usr/sbin/mysqldSep 22 18:10:59 localhost.localdomain systemd[1]: Starting MySQL Server...
Sep 22 18:11:03 localhost.localdomain systemd[1]: Started MySQL Server.
MySQL配置
-
安装成功后,自动创建mysql用户和mysql用户组
[root@localhost network-scripts]# id mysql uid=27(mysql) gid=27(mysql) groups=27(mysql)
-
安装后的默认路径,通过配置文件查看。
vi /etc/my.cnf 可以看到以下配置: datadir=/var/lib/mysql 数据文件默认位置,如果更改数据存储位置需要停止数据库将/var/lib/mysql下文件移动至更改位置 socket=/var/lib/mysql/mysql.sock socket默认位置log-error=/var/log/mysqld.log 日志默认位置 pid-file=/var/run/mysqld/mysqld.pid pid文件默认位置
-
查看初始密码.
[root@localhost etc]# cat /var/log/mysqld.log | grep password 2024-09-22T10:11:00.998249Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: bdx1Cqxyo&8F
-
本台服务器登陆更改密码并配置root远程登陆
[root@localhost etc]# mysql -uroot -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 9 Server version: 8.4.2Copyright (c) 2000, 2024, Oracle and/or its affiliates.Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. #注意:MySQL8之后,对密码强度要求更高,需要大写、数字、小写、特殊符合组合。 mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'Mzq123@_'; Query OK, 0 rows affected (0.01 sec) #然后刷新权限,使密码生效 mysql> flush privileges; Query OK, 0 rows affected (0.00 sec) #选中mysql数据库 mysql> use mysql; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -ADatabase changed #设置允许远程连接并生效 mysql> update user set host='%' where user='root'; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 #然后刷新权限 mysql> flush privileges; Query OK, 0 rows affected (0.01 sec)
连接成功