MYSQL安装教程

#下载mysql安装包
#下载完成的是一个类似的包 mysql80-community-release-el7-1.noarch.rpm
wget url
#安装已下载完成的包
yum localinstall packagename.rpm
#验证是否安装成功
yum repolist enabled | grep "mysql.*-community.*"
#安装mysql
yum install mysql-community-server -y
#查询安装包信息
rpm -qi mysql-community-server.x86_64 0:8.0.16-2.el7
#查看安装目录  /usr/bin/
whereis mysql
#启动mysql
systemctl start mysqld
systemctl enable mysqld
systemctl status mysqld

###########初始密码修改###########

#查询初始密码
cat /var/log/mysqld.log | grep password
#进入mysql
mysql -uroot -p
#修改初始密码
ALTER USER 'root'@'localhost' IDENTIFIED BY '你的密码';
#如果密码简单可能出现修改失败，这是进行密码规则查询
SHOW VARIABLES LIKE 'validate_password%';
#设置密码长度
set global validate_password.length=4;
#设置密码校验等级
set global validate_password.policy=0;

#######允许远程连接##########
use mysql;
select host,user,authentication_string,plugin from user;
update user set host='%' where user='root';
flush privileges;
#######修改字符集##########
mysql> status
#如果是utf8mb4不用修改
show VARIABLES like 'character%';
#修改数据库字符集，修改后重启
alter database 数据库名 character set utf8mb4;
#修改表字符集
ALTER TABLE  表名 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

参考：
https://www.cnblogs.com/baoshu/p/centos-mysql.html
https://www.cnblogs.com/easilyai/p/11549897.html