首先centos上一般会有默认自带的MariaDb数据库,但是为了我们的业务需要,我们还是要安装mysql,并且在安装完之后覆盖系统自带的MariaDB 数据,废话不多说,直接开整
wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm
下载完毕
2.安装mysql
yum -y install mysql57-community-release-el7-10.noarch.rpm报错:

开始debug
解决办法:
下载另一个版本的rpm包
wget http://dev.mysql.com/get/mysql57-community-release-el7-7.noarch.rpm本地安装
yum localinstall -y mysql57-community-release-el7-7.noarch.rpm再次尝试安装mysql
yum install -y mysql-community-server再次报错:

再次debug
加入公钥:
rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022之后再次尝试安装mysql
yum -y install mysql-community-server
安装mysql成功
3.启动mysql并查看状态
启动
systemctl start mysqld.service
查看状态
systemctl status mysqld.service
绿色的running => 启动成功
4.查看密码并且修改mysql的root账号密码
grep "password" /var/log/mysqld.log
最后几位就是我们的root密码
修改密码
先登录进去
mysql -uroot -p
输入指令:
ALTER USER 'root'@'localhost' IDENTIFIED BY 'new password';
报错
再次debug
查看mysql密码策略:
SHOW VARIABLES LIKE 'validate_password%';+--------------------------------------+--------+
| Variable_name | Value |
+--------------------------------------+--------+
| validate_password_check_user_name | OFF |
| validate_password_dictionary_file | |
| validate_password_length | 8 |
| validate_password_mixed_case_count | 1 |
| validate_password_number_count | 1 |
| validate_password_policy | MEDIUM |
| validate_password_special_char_count | 1 |
+--------------------------------------+--------+
7 rows in set (0.01 sec)
修改策略:
mysql> set global validate_password.policy=0;
mysql> set global validate_password.length=1;尝试修改密码:

修改成功
5.配置mysql的远程访问
授权
grant all privileges on *.* to 'root'@'%' identified by 'password' with grant option;
刷新权限
mysql> flush privileges;
尝试远程连接

连接成功。
完