centos7离线安装MySQL8

最新推荐文章于 2025-01-31 10:01:37 发布
最新推荐文章于 2025-01-31 10:01:37 发布
阅读量1.4k 收藏 18
点赞数 29
文章标签： mysql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/qq_42718098/article/details/142433853
版权

下载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

  1. 检查原先系统是否安装mysql
rpm -qa |grep -i mysql
  1. 安装了的话，卸载安装包
 yum remove mysql-community-libs-8.0.13-1.el7.x86_64 mysql-community-server-8.0.13-1.el7.x86_64
  1. 删除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
  1. 删除配置文件与日志
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

安装

  1. 安装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%]

  2. 安装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%]

  3. 安装 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%]

  4. 安装 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%]

  5. 安装 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%]

  6. 安装 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_64
        file /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

  7. 安装 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%]

  8. 装 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%]

  9. 安装 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_64
        net-tools is needed by mysql-community-server-8.4.2-1.el7.x86_64
        perl(Getopt::Long) is needed by mysql-community-server-8.4.2-1.el7.x86_64
        perl(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 Server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
   Active: active (running) since Sun 2024-09-22 18:11:03 CST; 5s ago
     Docs: man:mysqld(8)
           http://dev.mysql.com/doc/refman/en/using-systemd.html
  Process: 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/mysqld

Sep 22 18:10:59 localhost.localdomain systemd[1]: Starting MySQL Server...
Sep 22 18:11:03 localhost.localdomain systemd[1]: Started MySQL Server.

MySQL配置

  1. 安装成功后，自动创建mysql用户和mysql用户组

    [root@localhost network-scripts]# id mysql
uid=27(mysql) gid=27(mysql) groups=27(mysql)

  2. 安装后的默认路径，通过配置文件查看。

    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文件默认位置

  3. 查看初始密码.

    [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

  4. 本台服务器登陆更改密码并配置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.2

Copyright (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 -A

Database 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)

连接成功在这里插入图片描述

码上心动
关注
CentOS7下Mysql8.0.20离线rpm安装包
07-18
CentOS7下mysql8.0离线安装rpm包 具体安装步骤请参考：https://www.cnblogs.com/wdw984/p/13334727.html
centos7离线安装mysql8
04-23
### CentOS 7 离线安装 MySQL 8 步骤详解 #### 一、环境准备与清理 在开始安装MySQL 8之前，首先确保CentOS 7系统已更新至最新状态，这可以通过运行`yum update -y`命令完成。接着进行以下步骤： 1. **卸载现有...
Linux 查看用户列表
全村的希望的博客
09-23 866
命令 cat /etc/passwd
Centos7安装MySQL8
最新发布
2501_90207503的博客
01-31 663
rw------- 1 mysql mysql 1676 2月 17 18:05 private_key.pem。-rw------- 1 mysql mysql 1676 2月 17 18:05 client-key.pem。-rw------- 1 mysql mysql 1680 2月 17 18:05 server-key.pem。-rw------- 1 mysql mysql 1676 2月 17 18:05 ca-key.pem。
Centos7 离线安装 mysql8（亲自尝试过）
y19910825的博客
12-15 1495
在新买的阿里云服务器上面安装MySQL8，然而在初始化MySQL的时候报错了，报错详情是./mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory。因为可能是新的服务器环境，上面很多依赖都没有，所以安装软件的时候遇到一大堆小问题，解决它很简单，它缺少啥就安装啥。2) 创建用户，用户组。6) 启动MySQL。1.2 建立远程连接。
Centos 7离线安装MySql8
有出路CodingTime
03-25 4622
Centos 7离线安装MySql8 linux版本：Centos 7 mysql版本：mysql-8 一、安装 1、下载mysql离线安装包 下载地址：https://dev.mysql.com/downloads/mysql/ 选择如下： 【Red Hat Enterprise Linux 7 / Oracle Linux】 【Red Hat Enterprise Linux 7 / Oracle Linux 7 (x86, 64-bit)】 [外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来
CentOS7离线安装mysql8
little_crab_的博客
01-13 796
准备条件 mysql8安装包官网下载 上传到系统指定位置备用 一般放于/usr/local目录下 添加mysql用户组和用户 groupadd mysql useradd -r -g mysql -s /bin/false mysql 解压安装包 cd /usr/local/ xz -d mysql-8.0.26-linux-glibc2.17-x86_64-minimal-rebuild.tar.xz tar -xvf mysql-8.0.26-linux-glibc2.17-
CentOS7下离线安装MySQL8
Hatakefiftyfifty的博客
05-05 965
CentOS7 使用rpm方式安装MySQL8
centOS7离线安装mysql5.7.26完整rpm包.zip
04-20
标题中的"CentOS7离线安装mysql5.7.26完整rpm包.zip"表明了这个压缩包是为了在CentOS 7系统上离线安装MySQL 5.7.26版本而准备的。离线安装通常适用于没有互联网连接或者网络环境受限的服务器，通过提前下载所需的...
Centos7离线安装mysql8步骤
qq_42493814的博客
12-13 1299
将mysql解压到指定目录这里安装的是mysql-8.0.26 linux下tar命令解压到指定的目录 ： #tar zxvf xx.tar.gz-C/xx [解压] tar -xvf mysql-8.0.26-1.el7.x86_64.rpm-bundle.tar rpm -qa | grep -i mysql 【必须安装】 rpm -ivh mysql-community-common-8.0.26-1.el7.x86_64.rpm rpm -ivh mysql-communi..
最全Centos7离线安装MYSQL8(rpm安装方式)，亲测可以使用
qq_23931717的博客
03-16 1592
到这里mysql已经可以本地连接上了，但是要用图形化界面远程连接，还需要开发防火墙的3306端口才行。安装包名：mysql-8.0.13-1.el7.x86_64.rpm-bundle.tar。将压缩包上传至要进行安装的服务器 使用下方的命令进行解压，根据实际安装包名称进行修改。自此在linux系统上安装mysql8已经完成，并且可以使用图形化界面远程连接。拿到初始密码（若在my.cnf修改了路径，按my.cnf路径来）必须下载对应内核版本的安装包，否则将无法进行安装。5.给mysql的安装目录授权。
mysql8 centos离线安装
05-05
在Linux环境中，特别是CentOS系统上，MySQL 8.0的离线安装是一个常见的需求，尤其是在没有网络连接或者网络环境不稳定的情况下。以下是如何利用提供的压缩包文件进行离线安装MySQL 8.0的详细步骤： 首先，我们看到...
CentOS 7 RPM 离线安装 MySQL 8
君逍遥o
07-20 1640
CentOS 7 RPM 离线安装 MySQL 8
Centos7离线安装mysql8
yrsg666的博客
09-26 373
部署并不复杂，已经成功多次，整理了下主要参考的博文，如下： https://blog.csdn.net/weixin_42266606/article/details/80879571 图文并茂 注意事项： 上面安装时候可能会遇到密码无法修改报错：ERROR 1819 (HY000): Your password does not satisfy the current policy re...
centos7离线安装mysql8 笔记
王小右的博客
08-01 1446
前言：不知道为什么我的云服务器在线安装mysql特别特别慢，于是我手动下载安装了，mysql服务器(本来是想安装5.7的，下错了,查了下使用区别，对我而言这两个版本没啥区别) 首先在线安装 参考其他人的 https://blog.csdn.net/ManagementAndJava/article/details/80039650 但是对我而言，在线安装的时候太慢了，十几k每秒，无奈我就离线安...
Centos7离线安装Mysql8（rpm安装）
m0_47743175的博客
12-03 1780
Centos7离线安装Mysql8（rpm安装）
centos7 离线安装 mysql8
cuisidong1997的博客
10-16 634
1、下载rpm压缩包 下载地址： https://dev.mysql.com/downloads/mysql/ 选择适应的版本（根据自己系统选择合适的版本） 2，在/usr/local目录下新建目录mysql cd /usr/local mkdir mysql 3，上传mysql-8.0.18-1.el7.x86_64.rpm-bundle.tar然后进行解压 解压命令 tar -xvf mysql-8.0.18-1.el7.x86_64.rpm-bundle.tar 4、卸载mariadb 查看maria
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值