Centos 7配置Mysql

Centos 7安装Mysql详细步骤

一丶mysql安装
1.1,下载wget命令

yum -y install wget

1.2,在线下载mysql安装包

wget https://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm

1.3,安装mysql

rpm -ivh mysql57-community-release-el7-8.noarch.rpm

1.4,安装mysql服务

首先进入cd /etc/yum.repos.d/目录
cd /etc/yum.repos.d/
安装nysql服务
yum -y install mysql-server

1.5，启动mysql

systemctl start mysqld

1.6，获取mysql临时密码

grep 'temporary password' /var/log/mysqld.log

1.7,使用临时密码先登录

mysql -uroot -p

1.8，进入sql后将密码校验强度改为低风险

set global validate_password_policy=LOW;

1.9，修改mysql的密码长度

set global validate_password_length=4;

1.10，修改mysql密码

ALTER USER 'root'@'localhost' IDENTIFIED BY 'root'; 

二丶允许远程访问

2.1设置防火墙对mysql的端口号放行

firewall-cmd --zone=public --add-port=3306/tcp --permanent

2.2重启firewall设置

systemctl restart firewalld

2.3查询3306端口是否放行成功

firewall-cmd --list-ports

2.4修改密码后再重新登录

mysql -uroot -p

2.5切换到mysql数据库

use mysql;

2.6修改允许任何地址可以访问

update user set Host='%' where User='root';

2.7刷新权限

flush privileges;

原创不易，记得一键三连么么哒~~~