Centos7 安装最新版mysql， mysql8.0.18

#去官网查看最新安装包
https://dev.mysql.com/downloads/mysql/
目前使用版本：mysql-community-server-8.0.18-1.el7.aarch64.rpm

#上传文件
mkdir -p /usr/local/mysql
拷贝mysql-8.0.18-1.el7.x86_64.rpm-bundle.tar至/usr/local/mysql目录
#解压缩安装包
cd /usr/local/mysql
tar -xvf mysql-8.0.18-1.el7.x86_64.rpm-bundle.tar

#创建mysql用户和组
groupadd -g 2000 mysql
useradd mysql -g mysql -p mysql

#安装mysql服务器
yum install -y perl-Module-Install.noarch

rpm -ivh mysql-community-common-8.0.18-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-8.0.18-1.el7.x86_64.rpm --nodeps --force
rpm -ivh mysql-community-libs-compat-8.0.18-1.el7.x86_64.rpm --nodeps –force
rpm -ivh mysql-community-client-8.0.18-1.el7.x86_64.rpm --nodeps --force
rpm -ivh mysql-community-server-8.0.18-1.el7.x86_64.rpm --nodeps --force rpm -ivh mysql-community-devel-8.0.18-1.el7.x86_64.rpm --nodeps --force
#安装后查看相关信息
mysql -V
–配置文件位置
ll /etc/my.cnf
#重置root密码
my.cnf 增加配置项skip-grant-tables

vi /etc/my.cnf

重启mysql使参数生效
service mysqld restart
#修改root密码
mysql
mysql> flush privileges;
mysql> set global validate_password.policy=0; #密码强度设为最低等级
mysql>flush privileges; #更新授权表，生效
mysql> alter user root@‘localhost’ identified with mysql_native_password by ‘mysql123456’;#修改root密码为mysql123456
mysql>use mysql;
mysql>update user set password=password(‘mysql123456’) where user = ‘root’;
mysql>flush privileges; #更新授权表，生效

修改root密码后去掉my.cnf中配置项skip-grant-tables
vi /etc/my.cnf

#启动关闭命令
service mysqld start

service mysqld restart