查找mariadb
rpm -qa | grep mariadb
卸载mariadb
sudo rpm -e mariadb-libs-5.5.56-2.el7.x86_64 --nodeps
下载 mysql.rpm
wget https://repo.mysql.com//mysql80-community-release-el7-7.noarch.rpm
安装rpm
yum install -y mysql80-community-release-el7-7.noarch.rpm
查看一下安装效果
yum repolist enabled | grep mysql.*
mysql80-community/x86_64 MySQL 8.0 Community Server 346
安装 mysql-community-server
yum -y install mysql-community-server
启动MySQL服务
systemctl start mysqld.service
查看一下运行状态
systemctl status mysqld.service
关闭防火墙(慎重)
systemctl stop firewalld.service
systemctl disable firewalld.service
查看mysql自动生成密码
grep "password" /var/log/mysqld.log
登录mysql
mysql -uroot -p
初次登录,修改密码,
默认规则 大小字母,小写字母,特殊字符,8位
alter user user() identified by "123456Aa#";
修改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;
设置自动启动
systemctl enable mysqld
systemctl daemon-reload
修改mysql密码策略
SHOW VARIABLES LIKE 'validate_password%';
设置密码验证强度
set global validate_password.policy=LOW;
设置密码长度
set global validate_password.length=4;
alter user user() identified by "123456";