一、官网
二、安装
- 下载
wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.17-1.el7.x86_64.rpm-bundle.tar
- 解压并安装
# 解压
tar -xvf mysql-8.0.17-1.el7.x86_64.rpm-bundle.tar
# 依次安装顺序
rpm -vih mysql-community-common-8.0.17-1.el7.x86_64.rpm
rpm -vih mysql-community-libs-8.0.17-1.el7.x86_64.rpm
rpm -vih mysql-community-libs-compat-8.0.17-1.el7.x86_64.rpm
rpm -vih mysql-community-client-8.0.17-1.el7.x86_64.rpm
rpm -vih mysql-community-embedded-compat-8.0.17-1.el7.x86_64.rpm
rpm -vih mysql-community-server-8.0.17-1.el7.x86_64.rpm
可能存在的报错:
mariadb-libs is obsoleted by mysql-community-libs-8.0.17-1.el7.x86_64
原因是 cenos 7 默认的是mariadb数据库,所以要先卸载mariadb.
rpm -qa | grep mariadb | xargs rpm -e --nodeps
- 启动
systemctl start mysqld
- 查看密码
grep "password" /var/log/mysqld.log
- 修改密码策略并修改密码
# 登录
mysql -uroot -p
# 修改密码策略
set global validate_password.policy=0;
set global validate_password.mixed_case_count=0;
set global validate_password.number_count=3;
set global validate_password.special_char_count=0;
set global validate_password.length=3;
# 修改密码
alter user user() identified by "password";
CREATE USER 'root'@'%' IDENTIFIED BY 'password';
grant all privileges on *.* to 'root'@'%';
alter user 'root'@'%' identified with mysql_native_password by 'password';
flush privileges;