centos7下yum安装mysql(图文详解)

yum安装mysql5.7

一、下载安装mysql

1、下载mysql压缩包
mysql的bundle压缩包下载地址

2、解压压缩包

cd /usr/local/mysql
tar -xvf mysql-5.7.39-1.el7.x86_64.rpm-bundle.tar

3、检查postfix，mariadb是否存在并将其卸载

rpm -qa |grep postfix
rpm -qa | grep mariadb

检测依赖
rpm -e xxx
不检测依赖
rpm -e --nodeps xxx

4、按照顺序rpm安装解压出来的common包libs包client包server包

rpm -ivh xxx

5、运行

mysql -V
systemctl start mysqld
systemctl status mysqld

二、配置mysql

1、进入mysql

查看初始密码
grep "password" /var/log/mysqld.log
进入mysql
mysql -uroot -p'xxxx'

2、修改密码

设置密码强度
set global validate_password_policy=LOW; 
设置密码长度
set global validate_password_length=6;
修改密码
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';
查看密码策略
SHOW VARIABLES LIKE 'validate_password%';

3、配置mysql远程连接

use mysql;

update user set host = '%' where user = 'root';

FLUSH PRIVILEGES;

开放3306端口
firewall-cmd --add-port=3306/tcp --permanent
重启防火墙
systemctl restart firewalld

4、远程连接