本文适用于centos 8及以上安装mysql 8.0，整体耗时20分钟内，不需要翻墙
1.环境先搞好
systemctl stop firewalld //关闭防火墙 systemctl disable firewalld //禁用防火墙 setenforce 0 sed -i 's/^SELINUX=.*/SELINUX=disabled/' /etc/selinux/config timedatectl set-timezone Asia/Shanghai
2.开始安装
yum -y install mysql-server mysql mysql-devel //快速安装mysql mysqld --install --user=root mysqld --initialize --user=mysql mysqld --initialize --lower-case-table-names=1 //查看mysql日志，密码在日志中 mysql的安装位置在/var/lib/mysql/ cat /var/log/mysql/mysqld.log ///发现错误 Data Dictionary initialization failed
3.Data Dictionary initialization failed解决办法
rm -rf /var/lib/mysql mysqld --initialize --console chown -R mysql:mysql /var/lib/mysql/ systemctl start mysqld systemctl status mysqld cat /var/log/mysql/mysqld.log //A temporary password is generated for root@localhost: 冒号后面的就是初始密码
4.修改密码并开启远程访问
mysql -u root -p
//需要输入初始密码，进入mysql控制台 ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'test@123'; //修改密码为test@123 use mysql select Host,User from user; update user set host = '%' where user ='root'; //将host从localhost修改为全部 flush privileges; exit
5.其他操作
rpm -qa | grep mysql yum -y remove mysql.... //如果mysql已安装，执行删除 systemctl enable/start/stop/status servicename // enable //设置开机启动 ； start //启动 ； stop //停止 ；status状态
6.连接mysql
在虚拟机上的输入输出记录
Xshell 6 (Build 0189) Copyright (c) 2002 NetSarang Computer, Inc. All rights reserved. Type `help' to learn how to use Xshell prompt. [D:\~]$ Connecting to 192.168.5.133:22... Connection established. To escape to local shell, press 'Ctrl+Alt+]'. WARNING! The remote SSH server rejected X11 forwarding request. Activate the web console with: systemctl enable --now cockpit.socket Last login: Tue Sep 1 15:41:10 2020 [root@localhost ~]# systemctl stop firewalld [root@localhost ~]# systemctl disable firewalld Removed /etc/systemd/system/multi-user.target.wants/firewalld.service. Removed /etc/systemd/system/dbus-org.fedoraproject.FirewallD1.service. [root@localhost ~]# setenforce 0 [root@localhost ~]# sed -i 's/^SELINUX=.*/SELINUX=disabled/' /etc/selinux/config [root@localhost ~]# timedatectl set-timezone Asia/Shanghai [root@localhost ~]# yum -y install mysql-server mysql mysql-devel Last metadata expiration check: 0:11:14 ago on Tue 01 Sep 2020 03:51:03 PM CST. Dependencies resolved. =================================================================================== Package Arch Version Repo Size =================================================================================== Installing: mysql x86_64 8.0.17-3.module_el8.0.0+181+899d6349 AppStream 11 M mysql-devel x86_64 8.0.17-3.module_el8.0.0+181+899d6349 AppStream 147 k mysql-server x86_64 8.0.17-3.module_el8.0.0+181+899d6349 AppStream 22 M Installing dependencies: checkpolicy x86_64 2.9-1.el8 BaseOS 348 k keyutils-libs-devel x86_64 1.5.10-6.el8 BaseOS 48 k krb5-devel x86_64 1.17-18.el8 BaseOS 549 k libcom_err-devel x86_64 1.45.4-3.el8 BaseOS 38 k libevent x86_64 2.1.8-5.el8 BaseOS 253 k libkadm5 x86_64 1.17-18.el8 BaseOS 185 k libselinux-devel x86_64 2.9-3.el8 BaseOS 199 k libsepol-devel x86_64 2.9-1.el8 BaseOS 86 k libverto-devel x86_64 0.3.0-5.el8 BaseOS 18 k mariadb-connector-c-config noarch 3.0.7-1.el8 AppStream 13 k mecab x86_64 0.996-1.module_el8.0.0+41+ca30bab6.9 AppStream 397 k mysql-common x86_64 8.0.17-3.module_el8.0.0+181+899d6349 AppStream 143 k mysql-errmsg x86_64 8.0.17-3.module_el8.0.0+181+899d6349 AppStream 557 k mysql-libs x86_64 8.0.17-3.module_el8.0.0+181+899d6349 AppStream 1.2 M openssl-devel x86_64 1:1.1.1c-15.el8 BaseOS 2.3 M pcre2-devel x86_64 10.32-1.el8 BaseOS 605 k pcre2-utf16 x86_64 10.32-1.el8 BaseOS 228 k pcre2-utf32 x86_64 10.32-1.el8 BaseOS 220 k perl-Carp noarch 1.42-396.el8 BaseOS 30 k perl-Data-Dumper x86_64 2.167-399.el8 BaseOS 58 k perl-Digest noarch 1.17-395.el8 AppStream 27 k perl-Digest-MD5 x86_64 2.55-396.el8 AppStream 37 k perl-Encode x86_64 4:2.97-3.el8 BaseOS 1.5 M perl-Errno x86_64 1.28-416.el8 BaseOS 76 k perl-Exporter noarch 5.72-396.el8 BaseOS 34 k perl-File-Path noarch 2.15-2.el8 BaseOS 38 k perl-File-Temp noarch 0.230.600-1.el8 BaseOS 63 k perl-Getopt-Long noarch 1:2.50-4.el8 BaseOS 63 k perl-HTTP-Tiny noarch 0.074-1.el8 BaseOS 58 k perl-IO x86_64 1.38-416.el8 BaseOS 141 k perl-MIME-Base64 x86_64 3.15-396.el8 BaseOS 31 k perl-Net-SSLeay x86_64 1.88-1.el8 AppStream 379 k perl-PathTools x86_64 3.74-1.el8 BaseOS 90 k perl-Pod-Escapes noarch 1:1.07-395.el8 BaseOS 20 k perl-Pod-Perldoc noarch 3.28-396.el8 BaseOS 86 k perl-Pod-Simple noarch 1:3.35-395.el8 BaseOS 213 k perl-Pod-Usage noarch 4:1.69-395.el8 BaseOS 34 k perl-Scalar-List-Utils x86_64 3:1.49-2.el8 BaseOS 68 k perl-Socket x86_64 4:2.027-3.el8 BaseOS 59 k perl-Storable x86_64 1:3.11-3.el8 BaseOS 98 k perl-Term-ANSIColor noarch 4.06-396.el8 BaseOS 46 k perl-Term-Cap noarch 1.17-395.el8 BaseOS 23 k perl-Text-ParseWords noarch 3.30-395.el8 BaseOS 18 k perl-Text-Tabs+Wrap noarch 2013.0523-395.el8 BaseOS 24 k perl-Time-Local noarch 1:1.280-1.el8 BaseOS 34 k perl-URI noarch 1.73-3.el8 AppStream 116 k perl-Unicode-Normalize x86_64 1.25-396.el8 BaseOS 82 k perl-constant noarch 1.33-396.el8 BaseOS 25 k perl-interpreter x86_64 4:5.26.3-416.el8 BaseOS 6.3 M perl-libnet noarch 3.11-3.el8 AppStream 121 k perl-libs x86_64 4:5.26.3-416.el8 BaseOS 1.6 M perl-macros x86_64 4:5.26.3-416.el8 BaseOS 72 k perl-parent noarch 1:0.237-1.el8 BaseOS 20 k perl-podlators noarch 4.11-1.el8 BaseOS 118 k perl-threads x86_64 1:2.21-2.el8 BaseOS 61 k perl-threads-shared x86_64 1.58-2.el8 BaseOS 48 k policycoreutils-python-utils noarch 2.9-9.el8 BaseOS 251 k protobuf-lite x86_64 3.5.0-7.el8 AppStream 150 k python3-audit x86_64 3.0-0.17.20191104git1c2f876.el8 BaseOS 86 k python3-libsemanage x86_64 2.9-2.el8 BaseOS 127 k python3-policycoreutils noarch 2.9-9.el8 BaseOS 2.2 M python3-setools x86_64 4.2.2-2.el8 BaseOS 601 k zlib-devel x86_64 1.2.11-13.el8 BaseOS 57 k Installing weak dependencies: perl-IO-Socket-IP noarch 0.39-5.el8 AppStream 47 k perl-IO-Socket-SSL noarch 2.066-4.el8 AppStream 297 k perl-Mozilla-CA noarch 20160104-7.el8 AppStream 15 k Enabling module streams: mysql 8.0 Transaction Summary =================================================================================== Install 69 Packages Total download size: 55 M Installed size: 279 M Downloading Packages: (1/69): mariadb-connector-c-config-3.0.7-1.el8.noa 71 kB/s | 13 kB 00:00 [MIRROR] mysql-8.0.17-3.module_el8.0.0+181+899d6349.x86_64.rpm: Curl error (56): Failure when receiving data from the peer for http://mirror.lzu.edu.cn/centos/8.2.2004/AppStream/x86_64/os/Packages/mysql-8.0.17-3.module_el8.0.0+181+899d6349.x86_64.rpm [Recv failure: Connection reset by peer] [MIRROR] mysql-common-8.0.17-3.module_el8.0.0+181+899d6349.x86_64.rpm: Curl error (56): Failure when receiving data from the peer for http://mirror.lzu.edu.cn/centos/8.2.2004/AppStream/x86_64/os/Packages/mysql-common-8.0.17-3.module_el8.0.0+181+899d6349.x86_64.rpm [Recv failure: Connection reset by peer] (2/69): mysql-common-8.0.17-3.module_el8.0.0+181+8 602 kB/s | 143 kB 00:00 (3/69): mysql-devel-8.0.17-3.module_el8.0.0+181+89 2.3 MB/s | 147 kB 00:00 (4/69): mecab-0.996-1.module_el8.0.0+41+ca30bab6.9 562 kB/s | 397 kB 00:00 (5/69): mysql-errmsg-8.0.17-3.module_el8.0.0+181+8 2.5 MB/s | 557 kB 00:00 [MIRROR] mysql-libs-8.0.17-3.module_el8.0.0+181+899d6349.x86_64.rpm: Curl error (56): Failure when receiving data from the peer for http://mirror.lzu.edu.cn/centos/8.2.2004/AppStream/x86_64/os/Packages/mysql-libs-8.0.17-3.module_el8.0.0+181+899d6349.x86_64.rpm [Recv failure: Connection reset by peer] (6/69): mysql-libs-8.0.17-3.module_el8.0.0+181+899 2.2 MB/s | 1.2 MB 00:00 (7/69): perl-Digest-1.17-395.el8.noarch.rpm 379 kB/s | 27 kB 00:00 (8/69): perl-Digest-MD5-2.55-396.el8.x86_64.rpm 1.4 MB/s | 37 kB 00:00 (9/69): perl-IO-Socket-IP-0.39-5.el8.noarch.rpm 1.5 MB/s | 47 kB 00:00 (10/69): perl-IO-Socket-SSL-2.066-4.el8.noarch.rpm 264 kB/s | 297 kB 00:01 (11/69): perl-Mozilla-CA-20160104-7.el8.noarch.rpm 413 kB/s | 15 kB 00:00 (12/69): perl-Net-SSLeay-1.88-1.el8.x86_64.rpm 3.6 MB/s | 379 kB 00:00 (13/69): perl-URI-1.73-3.el8.noarch.rpm 2.8 MB/s | 116 kB 00:00 (14/69): perl-libnet-3.11-3.el8.noarch.rpm 3.4 MB/s | 121 kB 00:00 (15/69): protobuf-lite-3.5.0-7.el8.x86_64.rpm 4.0 MB/s | 150 kB 00:00 (16/69): checkpolicy-2.9-1.el8.x86_64.rpm 831 kB/s | 348 kB 00:00 (17/69): keyutils-libs-devel-1.5.10-6.el8.x86_64.r 470 kB/s | 48 kB 00:00 (18/69): krb5-devel-1.17-18.el8.x86_64.rpm 1.4 MB/s | 549 kB 00:00 (19/69): libcom_err-devel-1.45.4-3.el8.x86_64.rpm 304 kB/s | 38 kB 00:00 (20/69): libevent-2.1.8-5.el8.x86_64.rpm 1.6 MB/s | 253 kB 00:00 (21/69): libkadm5-1.17-18.el8.x86_64.rpm 1.6 MB/s | 185 kB 00:00 (22/69): libselinux-devel-2.9-3.el8.x86_64.rpm 1.7 MB/s | 199 kB 00:00 (23/69): libsepol-devel-2.9-1.el8.x86_64.rpm 994 kB/s | 86 kB 00:00 (24/69): libverto-devel-0.3.0-5.el8.x86_64.rpm 367 kB/s | 18 kB 00:00 (25/69): openssl-devel-1.1.1c-15.el8.x86_64.rpm 2.2 MB/s | 2.3 MB 00:01 (26/69): mysql-8.0.17-3.module_el8.0.0+181+899d634 1.9 MB/s | 11 MB 00:05 (27/69): mysql-server-8.0.17-3.module_el8.0.0+181+ 4.3 MB/s | 22 MB 00:04 (28/69): pcre2-devel-10.32-1.el8.x86_64.rpm 1.8 MB/s | 605 kB 00:00 (29/69): perl-Carp-1.42-396.el8.noarch.rpm 442 kB/s | 30 kB 00:00 (30/69): pcre2-utf16-10.32-1.el8.x86_64.rpm 678 kB/s | 228 kB 00:00 (31/69): perl-Data-Dumper-2.167-399.el8.x86_64.rpm 755 kB/s | 58 kB 00:00 (32/69): perl-Errno-1.28-416.el8.x86_64.rpm 557 kB/s | 76 kB 00:00 (33/69): pcre2-utf32-10.32-1.el8.x86_64.rpm 631 kB/s | 220 kB 00:00 (34/69): perl-Exporter-5.72-396.el8.noarch.rpm 476 kB/s | 34 kB 00:00 (35/69): perl-File-Path-2.15-2.el8.noarch.rpm 503 kB/s | 38 kB 00:00 (36/69): perl-File-Temp-0.230.600-1.el8.noarch.rpm 580 kB/s | 63 kB 00:00 (37/69): perl-Getopt-Long-2.50-4.el8.noarch.rpm 593 kB/s | 63 kB 00:00 (38/69): perl-HTTP-Tiny-0.074-1.el8.noarch.rpm 544 kB/s | 58 kB 00:00 (39/69): perl-MIME-Base64-3.15-396.el8.x86_64.rpm 377 kB/s | 31 kB 00:00 (40/69): perl-IO-1.38-416.el8.x86_64.rpm 738 kB/s | 141 kB 00:00 (41/69): perl-Pod-Escapes-1.07-395.el8.noarch.rpm 300 kB/s | 20 kB 00:00 (42/69): perl-PathTools-3.74-1.el8.x86_64.rpm 704 kB/s | 90 kB 00:00 (43/69): perl-Pod-Perldoc-3.28-396.el8.noarch.rpm 628 kB/s | 86 kB 00:00 (44/69): perl-Pod-Usage-1.69-395.el8.noarch.rpm 408 kB/s | 34 kB 00:00 (45/69): perl-Pod-Simple-3.35-395.el8.noarch.rpm 763 kB/s | 213 kB 00:00 (46/69): perl-Scalar-List-Utils-1.49-2.el8.x86_64. 597 kB/s | 68 kB 00:00 (47/69): perl-Socket-2.027-3.el8.x86_64.rpm 572 kB/s | 59 kB 00:00 (48/69): perl-Storable-3.11-3.el8.x86_64.rpm 682 kB/s | 98 kB 00:00 (49/69): perl-Term-ANSIColor-4.06-396.el8.noarch.r 502 kB/s | 46 kB 00:00 (50/69): perl-Term-Cap-1.17-395.el8.noarch.rpm 349 kB/s | 23 kB 00:00 (51/69): perl-Text-ParseWords-3.30-395.el8.noarch. 327 kB/s | 18 kB 00:00 (52/69): perl-Text-Tabs+Wrap-2013.0523-395.el8.noa 334 kB/s | 24 kB 00:00 (53/69): perl-Time-Local-1.280-1.el8.noarch.rpm 424 kB/s | 34 kB 00:00 (54/69): perl-Encode-2.97-3.el8.x86_64.rpm 1.1 MB/s | 1.5 MB 00:01 (55/69): perl-constant-1.33-396.el8.noarch.rpm 402 kB/s | 25 kB 00:00 (56/69): perl-Unicode-Normalize-1.25-396.el8.x86_6 889 kB/s | 82 kB 00:00 (57/69): perl-macros-5.26.3-416.el8.x86_64.rpm 539 kB/s | 72 kB 00:00 (58/69): perl-parent-0.237-1.el8.noarch.rpm 280 kB/s | 20 kB 00:00 (59/69): perl-podlators-4.11-1.el8.noarch.rpm 609 kB/s | 118 kB 00:00 (60/69): perl-threads-2.21-2.el8.x86_64.rpm 506 kB/s | 61 kB 00:00 (61/69): perl-threads-shared-1.58-2.el8.x86_64.rpm 468 kB/s | 48 kB 00:00 (62/69): policycoreutils-python-utils-2.9-9.el8.no 694 kB/s | 251 kB 00:00 (63/69): python3-audit-3.0-0.17.20191104git1c2f876 572 kB/s | 86 kB 00:00 (64/69): python3-libsemanage-2.9-2.el8.x86_64.rpm 615 kB/s | 127 kB 00:00 (65/69): perl-libs-5.26.3-416.el8.x86_64.rpm 839 kB/s | 1.6 MB 00:01 (66/69): python3-setools-4.2.2-2.el8.x86_64.rpm 691 kB/s | 601 kB 00:00 (67/69): zlib-devel-1.2.11-13.el8.x86_64.rpm 473 kB/s | 57 kB 00:00 (68/69): python3-policycoreutils-2.9-9.el8.noarch. 934 kB/s | 2.2 MB 00:02 (69/69): perl-interpreter-5.26.3-416.el8.x86_64.rp 1.2 MB/s | 6.3 MB 00:05