centos7开始,默认安装MariaDB,其是mysql的分支,所以想要安装官方mysql,需要使用官方yum源
附上参考链接
https://segmentfault.com/a/1190000019507071
https://baijiahao.baidu.com/s?id=1635943129880072406&wfr=spider&for=pc
https://www.cnblogs.com/yss818824/p/12349719.html
1.我们查看自己的版本信息
[xxxx@localhost ~]$ uname -r
3.10.0-862.el7.x86_64
官网:mysql官网
2.选择对应的版本进行下载
wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm
结果显示
Unable to establish SSL connection.
原因分析:unable to establish ssl connection
修改命令
wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm --no-check-certificat
3.安装mysql源
rpm -Uvh mysql80-community-release-el7-3.noarch.rpm
4.查看我们想要下载的版本是否在用
yum repolist all | grep mysql
5.下载mysql
yum install mysql-community-server
等待....该选择y的地方选择y
6.mysql初始设置
# 启动mysql
systemctl start mysqld.service
# 查看运行状态
systemctl status mysqld.service
# 找到系统初始root密码
grep "temporary password" /var/log/mysqld.log
# 登录数据库
mysql -uroot -p
# 把刚才显示的密码输上
# 修改密码 密码要包括大小写,数字,字符,不然会报错
ALTER USER 'root'@'localhost' IDENTIFIED BY 'new password';
flush privileges;
# 查看密码等级并修改 如果出现error,可以用flush privileges
SHOW VARIABLES LIKE 'validate_password%';
# 可选 flush privileges;
set global validate_password_policy=LOW;
# 可选 flush privileges;
set global validate_password_length=6;
# 可选 flush privileges;
# 修改成简单密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'new password';
flush privileges;
exit;
# 重新登录