本文适用于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/mysqlmysqld
–initialize –consolechown
-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 mysqlyum
-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.socketLast login: Tue Sep
1 15:41:10 2020
[root@localhost]# systemctl stop firewalld]# systemctl disable firewalld
[root@localhost
Removed /etc/systemd/system/multi-user.target.wants/firewalld.service.
Removed /etc/systemd/system/dbus-org.fedoraproject.FirewallD1.service.
[root@localhost]# setenforce 0]# sed -i ‘s/^SELINUX=.*/SELINUX=disabled/‘ /etc/selinux/config
[root@localhost
[root@localhost]# timedatectl set-timezone Asia/Shanghai]# yum -y install mysql-server mysql mysql-devel
[root@localhost
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.0Transaction Summary
===================================================================================
Install 69 PackagesTotal 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
———————————————————————————–
Total 4.0 MB/s | 55 MB 00:13
warning: /var/cache/dnf/AppStream-a520ed22b0a8a736/packages/mariadb-connector-c-config-3.0.7-1.el8.noarch.rpm: Header V3 RSA/SHA256 Signature, key ID 8483c65d: NOKEY
CentOS-8 - AppStream 961 kB/s | 1.6 kB 00:00
Importing GPG key 0x8483C65D:
Userid : “CentOS (CentOS Official Signing Key) <security@centos.org>“
Fingerprint: 99DB 70FA E1D7 CE22 7FB6 4882 05B5 55B3 8483 C65D
From : /etc/pki/rpm-gpg/RPM-GPG-KEY-centosofficial
Key imported successfully
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
Preparing : 1/1
Installing : perl-Exporter-5.72-396.el8.noarch 1/69
Installing : perl-libs-4:5.26.3-416.el8.x86_64 2/69
Installing : perl-Carp-1.42-396.el8.noarch 3/69
Installing : perl-Scalar-List-Utils-3:1.49-2.el8.x86_64 4/69
Installing : perl-parent-1:0.237-1.el8.noarch 5/69
Installing : perl-Text-ParseWords-3.30-395.el8.noarch 6/69
Installing : zlib-devel-1.2.11-13.el8.x86_64 7/69
Installing : mariadb-connector-c-config-3.0.7-1.el8.noarch 8/69
Installing : mysql-common-8.0.17-3.module_el8.0.0+181+899d6349.x86 9/69
Installing : mysql-8.0.17-3.module_el8.0.0+181+899d6349.x86_64 10/69
Installing : mysql-errmsg-8.0.17-3.module_el8.0.0+181+899d6349.x86 11/69
Installing : mysql-libs-8.0.17-3.module_el8.0.0+181+899d6349.x86_6 12/69
Installing : perl-Term-ANSIColor-4.06-396.el8.noarch 13/69
Installing : perl-macros-4:5.26.3-416.el8.x86_64 14/69
Installing : perl-Errno-1.28-416.el8.x86_64 15/69
Installing : perl-Socket-4:2.027-3.el8.x86_64 16/69
Installing : perl-Text-Tabs+Wrap-2013.0523-395.el8.noarch 17/69
Installing : perl-Unicode-Normalize-1.25-396.el8.x86_64 18/69
Installing : perl-File-Path-2.15-2.el8.noarch 19/69
Installing : perl-IO-1.38-416.el8.x86_64 20/69
Installing : perl-PathTools-3.74-1.el8.x86_64 21/69
Installing : perl-constant-1.33-396.el8.noarch 22/69
Installing : perl-threads-1:2.21-2.el8.x86_64 23/69
Installing : perl-threads-shared-1.58-2.el8.x86_64 24/69
Installing : perl-interpreter-4:5.26.3-416.el8.x86_64 25/69
Installing : perl-MIME-Base64-3.15-396.el8.x86_64 26/69
Installing : perl-IO-Socket-IP-0.39-5.el8.noarch 27/69
Installing : perl-Time-Local-1:1.280-1.el8.noarch 28/69
Installing : perl-Digest-1.17-395.el8.noarch 29/69
Installing : perl-Digest-MD5-2.55-396.el8.x86_64 30/69
Installing : perl-Net-SSLeay-1.88-1.el8.x86_64 31/69
Installing : perl-Data-Dumper-2.167-399.el8.x86_64 32/69
Installing : perl-File-Temp-0.230.600-1.el8.noarch 33/69
Installing : perl-Pod-Escapes-1:1.07-395.el8.noarch 34/69
Installing : perl-Storable-1:3.11-3.el8.x86_64 35/69
Installing : perl-Term-Cap-1.17-395.el8.noarch 36/69
Installing : perl-Mozilla-CA-20160104-7.el8.noarch 37/69
Installing : perl-Encode-4:2.97-3.el8.x86_64 38/69
Installing : perl-Pod-Simple-1:3.35-395.el8.noarch 39/69
Installing : perl-Getopt-Long-1:2.50-4.el8.noarch 40/69
Installing : perl-podlators-4.11-1.el8.noarch 41/69
Installing : perl-Pod-Usage-4:1.69-395.el8.noarch 42/69
Installing : perl-Pod-Perldoc-3.28-396.el8.noarch 43/69
Installing : perl-HTTP-Tiny-0.074-1.el8.noarch 44/69
Installing : perl-IO-Socket-SSL-2.066-4.el8.noarch 45/69
Installing : perl-libnet-3.11-3.el8.noarch 46/69
Installing : perl-URI-1.73-3.el8.noarch 47/69
Installing : python3-setools-4.2.2-2.el8.x86_64 48/69
Installing : python3-libsemanage-2.9-2.el8.x86_64 49/69
Installing : python3-audit-3.0-0.17.20191104git1c2f876.el8.x86_64 50/69
Installing : pcre2-utf32-10.32-1.el8.x86_64 51/69
Installing : pcre2-utf16-10.32-1.el8.x86_64 52/69
Installing : pcre2-devel-10.32-1.el8.x86_64 53/69
Installing : libverto-devel-0.3.0-5.el8.x86_64 54/69
Installing : libsepol-devel-2.9-1.el8.x86_64 55/69
Installing : libselinux-devel-2.9-3.el8.x86_64 56/69
Installing : libkadm5-1.17-18.el8.x86_64 57/69
Installing : libevent-2.1.8-5.el8.x86_64 58/69
Installing : libcom_err-devel-1.45.4-3.el8.x86_64 59/69
Installing : keyutils-libs-devel-1.5.10-6.el8.x86_64 60/69
Installing : krb5-devel-1.17-18.el8.x86_64 61/69
Installing : openssl-devel-1:1.1.1c-15.el8.x86_64 62/69
Installing : checkpolicy-2.9-1.el8.x86_64 63/69
Installing : python3-policycoreutils-2.9-9.el8.noarch 64/69
Installing : policycoreutils-python-utils-2.9-9.el8.noarch 65/69
Installing : protobuf-lite-3.5.0-7.el8.x86_64 66/69
Installing : mecab-0.996-1.module_el8.0.0+41+ca30bab6.9.x86_64 67/69
Running scriptlet: mecab-0.996-1.module_el8.0.0+41+ca30bab6.9.x86_64 67/69
Running scriptlet: mysql-server-8.0.17-3.module_el8.0.0+181+899d6349.x86 68/69
Installing : mysql-server-8.0.17-3.module_el8.0.0+181+899d6349.x86 68/69
Running scriptlet: mysql-server-8.0.17-3.module_el8.0.0+181+899d6349.x86 68/69
ValueError: File context for /var/log/mysql(/.*)? already definedInstalling : mysql
-devel-8.0.17-3.module_el8.0.0+181+899d6349.x86_ 69/69
Running scriptlet: mysql-devel-8.0.17-3.module_el8.0.0+181+899d6349.x86_ 69/69
Verifying : mariadb-connector-c-config-3.0.7-1.el8.noarch 1/69
Verifying : mecab-0.996-1.module_el8.0.0+41+ca30bab6.9.x86_64 2/69
Verifying : mysql-8.0.17-3.module_el8.0.0+181+899d6349.x86_64 3/69
Verifying : mysql-common-8.0.17-3.module_el8.0.0+181+899d6349.x86 4/69
Verifying : mysql-devel-8.0.17-3.module_el8.0.0+181+899d6349.x86_ 5/69
Verifying : mysql-errmsg-8.0.17-3.module_el8.0.0+181+899d6349.x86 6/69
Verifying : mysql-libs-8.0.17-3.module_el8.0.0+181+899d6349.x86_6 7/69
Verifying : mysql-server-8.0.17-3.module_el8.0.0+181+899d6349.x86 8/69
Verifying : perl-Digest-1.17-395.el8.noarch 9/69
Verifying : perl-Digest-MD5-2.55-396.el8.x86_64 10/69
Verifying : perl-IO-Socket-IP-0.39-5.el8.noarch 11/69
Verifying : perl-IO-Socket-SSL-2.066-4.el8.noarch 12/69
Verifying : perl-Mozilla-CA-20160104-7.el8.noarch 13/69
Verifying : perl-Net-SSLeay-1.88-1.el8.x86_64 14/69
Verifying : perl-URI-1.73-3.el8.noarch 15/69
Verifying : perl-libnet-3.11-3.el8.noarch 16/69
Verifying : protobuf-lite-3.5.0-7.el8.x86_64 17/69
Verifying : checkpolicy-2.9-1.el8.x86_64 18/69
Verifying : keyutils-libs-devel-1.5.10-6.el8.x86_64 19/69
Verifying : krb5-devel-1.17-18.el8.x86_64 20/69
Verifying : libcom_err-devel-1.45.4-3.el8.x86_64 21/69
Verifying : libevent-2.1.8-5.el8.x86_64 22/69
Verifying : libkadm5-1.17-18.el8.x86_64 23/69
Verifying : libselinux-devel-2.9-3.el8.x86_64 24/69
Verifying : libsepol-devel-2.9-1.el8.x86_64 25/69
Verifying : libverto-devel-0.3.0-5.el8.x86_64 26/69
Verifying : openssl-devel-1:1.1.1c-15.el8.x86_64 27/69
Verifying : pcre2-devel-10.32-1.el8.x86_64 28/69
Verifying : pcre2-utf16-10.32-1.el8.x86_64 29/69
Verifying : pcre2-utf32-10.32-1.el8.x86_64 30/69
Verifying : perl-Carp-1.42-396.el8.noarch 31/69
Verifying : perl-Data-Dumper-2.167-399.el8.x86_64 32/69
Verifying : perl-Encode-4:2.97-3.el8.x86_64 33/69
Verifying : perl-Errno-1.28-416.el8.x86_64 34/69
Verifying : perl-Exporter-5.72-396.el8.noarch 35/69
Verifying : perl-File-Path-2.15-2.el8.noarch 36/69
Verifying : perl-File-Temp-0.230.600-1.el8.noarch 37/69
Verifying : perl-Getopt-Long-1:2.50-4.el8.noarch 38/69
Verifying : perl-HTTP-Tiny-0.074-1.el8.noarch 39/69
Verifying : perl-IO-1.38-416.el8.x86_64 40/69
Verifying : perl-MIME-Base64-3.15-396.el8.x86_64 41/69
Verifying : perl-PathTools-3.74-1.el8.x86_64 42/69
Verifying : perl-Pod-Escapes-1:1.07-395.el8.noarch 43/69
Verifying : perl-Pod-Perldoc-3.28-396.el8.noarch 44/69
Verifying : perl-Pod-Simple-1:3.35-395.el8.noarch 45/69
Verifying : perl-Pod-Usage-4:1.69-395.el8.noarch 46/69
Verifying : perl-Scalar-List-Utils-3:1.49-2.el8.x86_64 47/69
Verifying : perl-Socket-4:2.027-3.el8.x86_64 48/69
Verifying : perl-Storable-1:3.11-3.el8.x86_64 49/69
Verifying : perl-Term-ANSIColor-4.06-396.el8.noarch 50/69
Verifying : perl-Term-Cap-1.17-395.el8.noarch 51/69
Verifying : perl-Text-ParseWords-3.30-395.el8.noarch 52/69
Verifying : perl-Text-Tabs+Wrap-2013.0523-395.el8.noarch 53/69
Verifying : perl-Time-Local-1:1.280-1.el8.noarch 54/69
Verifying : perl-Unicode-Normalize-1.25-396.el8.x86_64 55/69
Verifying : perl-constant-1.33-396.el8.noarch 56/69
Verifying : perl-interpreter-4:5.26.3-416.el8.x86_64 57/69
Verifying : perl-libs-4:5.26.3-416.el8.x86_64 58/69
Verifying : perl-macros-4:5.26.3-416.el8.x86_64 59/69
Verifying : perl-parent-1:0.237-1.el8.noarch 60/69
Verifying : perl-podlators-4.11-1.el8.noarch 61/69
Verifying : perl-threads-1:2.21-2.el8.x86_64 62/69
Verifying : perl-threads-shared-1.58-2.el8.x86_64 63/69
Verifying : policycoreutils-python-utils-2.9-9.el8.noarch 64/69
Verifying : python3-audit-3.0-0.17.20191104git1c2f876.el8.x86_64 65/69
Verifying : python3-libsemanage-2.9-2.el8.x86_64 66/69
Verifying : python3-policycoreutils-2.9-9.el8.noarch 67/69
Verifying : python3-setools-4.2.2-2.el8.x86_64 68/69
Verifying : zlib-devel-1.2.11-13.el8.x86_64 69/69Installed:
-2.9-1.el8.x86_64
checkpolicy
keyutils-libs-devel-1.5.10-6.el8.x86_64
krb5-devel-1.17-18.el8.x86_64
libcom_err-devel-1.45.4-3.el8.x86_64
libevent-2.1.8-5.el8.x86_64
libkadm5-1.17-18.el8.x86_64
libselinux-devel-2.9-3.el8.x86_64
libsepol-devel-2.9-1.el8.x86_64
libverto-devel-0.3.0-5.el8.x86_64
mariadb-connector-c-config-3.0.7-1.el8.noarch
mecab-0.996-1.module_el8.0.0+41+ca30bab6.9.x86_64
mysql-8.0.17-3.module_el8.0.0+181+899d6349.x86_64
mysql-common-8.0.17-3.module_el8.0.0+181+899d6349.x86_64
mysql-devel-8.0.17-3.module_el8.0.0+181+899d6349.x86_64
mysql-errmsg-8.0.17-3.module_el8.0.0+181+899d6349.x86_64
mysql-libs-8.0.17-3.module_el8.0.0+181+899d6349.x86_64
mysql-server-8.0.17-3.module_el8.0.0+181+899d6349.x86_64
openssl-devel-1:1.1.1c-15.el8.x86_64
pcre2-devel-10.32-1.el8.x86_64
pcre2-utf16-10.32-1.el8.x86_64
pcre2-utf32-10.32-1.el8.x86_64
perl-Carp-1.42-396.el8.noarch
perl-Data-Dumper-2.167-399.el8.x86_64
perl-Digest-1.17-395.el8.noarch
perl-Digest-MD5-2.55-396.el8.x86_64
perl-Encode-4:2.97-3.el8.x86_64
perl-Errno-1.28-416.el8.x86_64
perl-Exporter-5.72-396.el8.noarch
perl-File-Path-2.15-2.el8.noarch
perl-File-Temp-0.230.600-1.el8.noarch
perl-Getopt-Long-1:2.50-4.el8.noarch
perl-HTTP-Tiny-0.074-1.el8.noarch
perl-IO-1.38-416.el8.x86_64
perl-IO-Socket-IP-0.39-5.el8.noarch
perl-IO-Socket-SSL-2.066-4.el8.noarch
perl-MIME-Base64-3.15-396.el8.x86_64
perl-Mozilla-CA-20160104-7.el8.noarch
perl-Net-SSLeay-1.88-1.el8.x86_64
perl-PathTools-3.74-1.el8.x86_64
perl-Pod-Escapes-1:1.07-395.el8.noarch
perl-Pod-Perldoc-3.28-396.el8.noarch
perl-Pod-Simple-1:3.35-395.el8.noarch
perl-Pod-Usage-4:1.69-395.el8.noarch
perl-Scalar-List-Utils-3:1.49-2.el8.x86_64
perl-Socket-4:2.027-3.el8.x86_64
perl-Storable-1:3.11-3.el8.x86_64
perl-Term-ANSIColor-4.06-396.el8.noarch
perl-Term-Cap-1.17-395.el8.noarch
perl-Text-ParseWords-3.30-395.el8.noarch
perl-Text-Tabs+Wrap-2013.0523-395.el8.noarch
perl-Time-Local-1:1.280-1.el8.noarch
perl-URI-1.73-3.el8.noarch
perl-Unicode-Normalize-1.25-396.el8.x86_64
perl-constant-1.33-396.el8.noarch
perl-interpreter-4:5.26.3-416.el8.x86_64
perl-libnet-3.11-3.el8.noarch
perl-libs-4:5.26.3-416.el8.x86_64
perl-macros-4:5.26.3-416.el8.x86_64
perl-parent-1:0.237-1.el8.noarch
perl-podlators-4.11-1.el8.noarch
perl-threads-1:2.21-2.el8.x86_64
perl-threads-shared-1.58-2.el8.x86_64
policycoreutils-python-utils-2.9-9.el8.noarch
protobuf-lite-3.5.0-7.el8.x86_64
python3-audit-3.0-0.17.20191104git1c2f876.el8.x86_64
python3-libsemanage-2.9-2.el8.x86_64
python3-policycoreutils-2.9-9.el8.noarch
python3-setools-4.2.2-2.el8.x86_64
zlib-devel-1.2.11-13.el8.x86_64Complete
!
[root@localhost]# mysqld –install –user=root]# mysqld –initialize –user=mysql
[root@localhost
[root@localhost]# mysqld –initialize –lower-case-table-names=1]# cat /var/log/mysql/mysqld.log
[root@localhost
2020-09-01T08:03:16.286242Z 0 [System] [MY-010116] [Server] /usr/libexec/mysqld (mysqld 8.0.17) starting as process 8036
2020-09-01T08:03:16.300375Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2020-09-01T08:03:16.300446Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2020-09-01T08:03:16.300498Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-09-01T08:03:16.300755Z 0 [System] [MY-010910] [Server] /usr/libexec/mysqld: Shutdown complete (mysqld 8.0.17) Source distribution.
2020-09-01T08:03:25.523538Z 0 [System] [MY-013169] [Server] /usr/libexec/mysqld (mysqld 8.0.17) initializing of server in progress as process 22923
2020-09-01T08:03:25.524591Z 0 [ERROR] [MY-010457] [Server] –initialize specified but the data directory has files in it. Aborting.
2020-09-01T08:03:25.524614Z 0 [ERROR] [MY-013236] [Server] The designated data directory /var/lib/mysql/ is unusable. You can remove all files that the server added to it.
2020-09-01T08:03:25.524676Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-09-01T08:03:25.524752Z 0 [System] [MY-010910] [Server] /usr/libexec/mysqld: Shutdown complete (mysqld 8.0.17) Source distribution.
2020-09-01T08:03:35.984050Z 0 [System] [MY-013169] [Server] /usr/libexec/mysqld (mysqld 8.0.17) initializing of server in progress as process 28279
2020-09-01T08:03:35.985204Z 0 [ERROR] [MY-010457] [Server] –initialize specified but the data directory has files in it. Aborting.
2020-09-01T08:03:35.985285Z 0 [ERROR] [MY-013236] [Server] The designated data directory /var/lib/mysql/ is unusable. You can remove all files that the server added to it.
2020-09-01T08:03:35.985321Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-09-01T08:03:35.985395Z 0 [System] [MY-010910] [Server] /usr/libexec/mysqld: Shutdown complete (mysqld 8.0.17) Source distribution.
[root@localhost]# rm -rf /var/lib/mysql]# mysqld –initialize –console
[root@localhost
[root@localhost]# chown -R mysql:mysql /var/lib/mysql/]# systemctl start mysqld
[root@localhost
[root@localhost ~]# systemctl status mysqld
● mysqld.service - MySQL 8.0 database server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; disabled; vendor preset>
Active: active (running) since Tue 2020-09-01 16:04:21 CST; 5s ago
Process: 28436 ExecStartPost=/usr/libexec/mysql-check-upgrade (code=exited, stat>
Process: 28356 ExecStartPre=/usr/libexec/mysql-prepare-db-dir mysqld.service (co>
Process: 28332 ExecStartPre=/usr/libexec/mysql-check-socket (code=exited, status>
Main PID: 28393 (mysqld)
Status: “Server is operational“
Tasks: 39 (limit: 11302)
Memory: 382.4M
CGroup: /system.slice/mysqld.service
└─28393 /usr/libexec/mysqld –basedir=/usrSep
01 16:04:18 localhost.localdomain systemd[1]: Starting MySQL 8.0 database serv>
Sep 01 16:04:21 localhost.localdomain mysql-check-upgrade[28436]: The datadir loca>
Sep 01 16:04:21 localhost.localdomain mysql-check-upgrade[28436]: 1. Back-up you>
Sep 01 16:04:21 localhost.localdomain mysql-check-upgrade[28436]: 2. Start the d>
Sep 01 16:04:21 localhost.localdomain mysql-check-upgrade[28436]: 3. Run ‘mysql_>
Sep 01 16:04:21 localhost.localdomain mysql-check-upgrade[28436]: Read more about >
Sep 01 16:04:21 localhost.localdomain mysql-check-upgrade[28436]: http://dev.mysql>
Sep 01 16:04:21 localhost.localdomain systemd[1]: Started MySQL 8.0 database serve>[root@localhost
]# ^C]# cat /var/log/mysql/mysqld.log
[root@localhost
2020-09-01T08:03:16.286242Z 0 [System] [MY-010116] [Server] /usr/libexec/mysqld (mysqld 8.0.17) starting as process 8036
2020-09-01T08:03:16.300375Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2020-09-01T08:03:16.300446Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2020-09-01T08:03:16.300498Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-09-01T08:03:16.300755Z 0 [System] [MY-010910] [Server] /usr/libexec/mysqld: Shutdown complete (mysqld 8.0.17) Source distribution.
2020-09-01T08:03:25.523538Z 0 [System] [MY-013169] [Server] /usr/libexec/mysqld (mysqld 8.0.17) initializing of server in progress as process 22923
2020-09-01T08:03:25.524591Z 0 [ERROR] [MY-010457] [Server] –initialize specified but the data directory has files in it. Aborting.
2020-09-01T08:03:25.524614Z 0 [ERROR] [MY-013236] [Server] The designated data directory /var/lib/mysql/ is unusable. You can remove all files that the server added to it.
2020-09-01T08:03:25.524676Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-09-01T08:03:25.524752Z 0 [System] [MY-010910] [Server] /usr/libexec/mysqld: Shutdown complete (mysqld 8.0.17) Source distribution.
2020-09-01T08:03:35.984050Z 0 [System] [MY-013169] [Server] /usr/libexec/mysqld (mysqld 8.0.17) initializing of server in progress as process 28279
2020-09-01T08:03:35.985204Z 0 [ERROR] [MY-010457] [Server] –initialize specified but the data directory has files in it. Aborting.
2020-09-01T08:03:35.985285Z 0 [ERROR] [MY-013236] [Server] The designated data directory /var/lib/mysql/ is unusable. You can remove all files that the server added to it.
2020-09-01T08:03:35.985321Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-09-01T08:03:35.985395Z 0 [System] [MY-010910] [Server] /usr/libexec/mysqld: Shutdown complete (mysqld 8.0.17) Source distribution.
2020-09-01T08:04:00.208778Z 0 [System] [MY-013169] [Server] /usr/libexec/mysqld (mysqld 8.0.17) initializing of server in progress as process 28282
2020-09-01T08:04:02.022251Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: u;*pHkkhe13T
2020-09-01T08:04:02.704903Z 0 [System] [MY-013170] [Server] /usr/libexec/mysqld (mysqld 8.0.17) initializing of server has completed
2020-09-01T08:04:19.678034Z 0 [System] [MY-010116] [Server] /usr/libexec/mysqld (mysqld 8.0.17) starting as process 28393
2020-09-01T08:04:21.444889Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2020-09-01T08:04:21.463100Z 0 [System] [MY-010931] [Server] /usr/libexec/mysqld: ready for connections. Version: ‘8.0.17‘ socket: ‘/var/lib/mysql/mysql.sock‘ port: 3306 Source distribution.
2020-09-01T08:04:21.531457Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: ‘/var/lib/mysql/mysqlx.sock‘ bind-address: ‘::‘ port: 33060
[root@localhost ~]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.17Copyright (c)
2000, 2019, Oracle and/or its affiliates. All rights reserved.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.mysql
> ALTER USER ‘root‘@‘localhost‘ IDENTIFIED WITH mysql_native_password BY ‘test@123‘;
Query OK, 0 rows affected (0.01 sec)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
> select Host,User from user;
mysql
+———–+——————+
| Host | User |
+———–+——————+
| localhost | mysql.infoschema |
| localhost | mysql.session |
| localhost | mysql.sys |
| localhost | root |
+———–+——————+
4 rows in set (0.00 sec)mysql
> update user set host = ‘%‘ where user =‘root‘;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0mysql
> flush privileges;
Query OK, 0 rows affected (0.01 sec)mysql
> exit
Bye
[root@localhost ~]#
