centos-7安装mysql-8

查找mariadb

rpm -qa | grep mariadb
1

卸载mariadb

sudo rpm -e mariadb-libs-5.5.56-2.el7.x86_64 --nodeps
1

下载 mysql.rpm

wget https://repo.mysql.com//mysql80-community-release-el7-7.noarch.rpm
1

安装rpm

yum install -y mysql80-community-release-el7-7.noarch.rpm
1

查看一下安装效果

yum repolist enabled | grep mysql.*
1

mysql80-community/x86_64                MySQL 8.0 Community Server           346
1

安装 mysql-community-server

yum -y install mysql-community-server
1

启动MySQL服务

systemctl start  mysqld.service
查看一下运行状态 
systemctl status mysqld.service
1
2
3

关闭防火墙(慎重)

systemctl stop firewalld.service
systemctl disable firewalld.service
1
2

查看mysql自动生成密码

grep "password" /var/log/mysqld.log
1

登录mysql

mysql -uroot -p
1

初次登录，修改密码，

默认规则 大小字母，小写字母，特殊字符，8位
alter user user() identified by "123456Aa#";
1
2

修改root账号可远程登录

use mysql;
update user set host = '%' where user = 'root'; 
select host, user from user; 
授权
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'WITH GRANT OPTION;
刷新
FLUSH PRIVILEGES; 
1
2
3
4
5
6
7

设置自动启动

systemctl enable mysqld
systemctl daemon-reload
1
2

修改mysql密码策略

SHOW VARIABLES LIKE 'validate_password%'; 

设置密码验证强度
set global validate_password.policy=LOW;

设置密码长度
set global validate_password.length=4;


alter user user() identified by "123456";
1
2
3
4
5
6
7
8
9
10