centOS7安装MySQL8

社区版mysql下载路径:

https://downloads.mysql.com/archives/community/

选择合适的版本，和对应的操作系统：

下载mysql组件:

RPM Bundle是全部安装包的集合：

这里我们下载安装以下5个安装包, 或者通过RPM Bundle全部下载之后然后挑出来:

对应的安装包为:

[root@mysql8 mysql_files]# ls -lrt

total 380284

-rw-r--r--. 1 root root  26760484 Jul 18 22:53 mysql-community-client-8.0.11-1.el7.x86_64.rpm

-rw-r--r--. 1 root root    549512 Jul 18 22:53 mysql-community-common-8.0.11-1.el7.x86_64.rpm

-rw-r--r--. 1 root root   2349488 Jul 18 22:53 mysql-community-libs-8.0.11-1.el7.x86_64.rpm

-rw-r--r--. 1 root root   2156516 Jul 18 22:53 mysql-community-libs-compat-8.0.11-1.el7.x86_64.rpm

-rw-r--r--. 1 root root 357581528 Jul 18 22:53 mysql-community-server-8.0.11-1.el7.x86_64.rpm

安装前准备:

yum install net-tools

yum install perl

安装mysql之前要先卸载mariadb:

rpm -e --nodeps mariadb-libs-5.5.64-1.el7.x86_64

rpm -qa | grep mariadb

按顺序安装:

rpm -ivh mysql-community-common-8.0.11-1.el7.x86_64.rpm

rpm -ivh mysql-community-libs-8.0.11-1.el7.x86_64.rpm

rpm -ivh  mysql-community-libs-compat-8.0.11-1.el7.x86_64.rpm

rpm -ivh mysql-community-client-8.0.11-1.el7.x86_64.rpm

rpm -ivh mysql-community-server-8.0.11-1.el7.x86_64.rpm

安装完成，启动MySQL服务:

service mysqld start

首次登陆:

[root@mysql8 mysql_files]# mysql -uroot

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

提示无权限，并生成一个临时密码，在/var/log/ mysqld.log中，为hsh!re.)k6AU， 如下:

[root@mysql8 mysql_files]# more /var/log/mysqld.log

2021-07-18T15:10:21.432620Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.11) initializing of server in progress as process 1869

2021-07-18T15:10:22.768799Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: hsh!re.)k6AU

2021-07-18T15:10:23.752836Z 0 [System] [MY-013170] [Server] /usr/sbin/mysqld (mysqld 8.0.11) initializing of server has completed

2021-07-18T15:10:25.508040Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.11) starting as process 1917

2021-07-18T15:10:25.870791Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.

2021-07-18T15:10:25.889143Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.11'  socket: '/var/lib/mysql/mysql.sock' 

port: 3306  MySQL Community Server - GPL.

用以下命令，输入该临时密码hsh!re.)k6AU，登陆:

mysql -uroot -p

临时密码经常权限受限，建议修改密码为固定密码:

alter user 'root'@'localhost' identified by "Test@123";