Linux下安装MySQL8.0

​​​1、下载rpm安装包

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

2、上传至服务器

3、解压

tar -xf mysql-8.0.16-2.el7.x86_64.rpm-bundle.tar

4、解压后，在当前目录执行安装

按顺序执行，若第（2）步出错则执行：yum remove mysql-libs

（1）rpm -ivh mysql-community-common-8.0.16-2.el7.x86_64.rpm

（2）rpm -ivh mysql-community-libs-8.0.16-2.el7.x86_64.rpm

（3）rpm -ivh mysql-community-client-8.0.16-2.el7.x86_64.rpm

（4）rpm -ivh mysql-community-server-8.0.16-2.el7.x86_64.rpm

5、修改大小写不敏感（可选）

vim /etc/my.cnf

加入下面行

lower_case_table_names=1

6、启动

systemctl start mysqld

启动成功后，查看启动状态

systemctl status mysqld

7、修改密码

查看临时密码

cat /var/log/mysqld.log | grep "temporary password"

登录

mysql -uroot -p'临时密码'

先修改为以下复杂密码

alter user user() identified by "Aa123456.";

设置密码等级

set global validate_password.policy=0;

修改为简单密码

alter user user() identified by "你的密码";

8、配置允许被连接

use mysql
update user set host = '%' where user = 'root' and host='localhost';

9、刷新

FLUSH  PRIVILEGES;