mysql搭建

比较简单,但是搭的比较多,写个文档以后懒得查了

1.安装mysql yum源

yum -y install mysql57-community-release-el7-11.noarch.rpm

报错了,是yum源的问题

2.查看已安装的yum源

rpm -qa |grep mysql 

3.卸载

rpm -e --nodeps mysql-community-release-el7-5.noarch

4.重新安装yum mysql源

yum -y install mysql57-community-release-el7-11.noarch.rpm

5.安装mysql

yum -y install mysql-server --nogpgcheck --nogpgcheck #不校验数字签名

6.启动 mysql

systemctl start mysqld.service
systemctl status mysqld.service

7.查看初始化密码

cat /var/log/mysqld.log| grep password

8.进入mysql

mysql -uroot -p

9.修改mysql root密码

#先修改为复杂的密码,否则无法操作
ALTER USER USER() IDENTIFIED BY 'Root@123';
#修改密码长度限制
set global validate_password_length=4;
#修改密码安全等级
set global validate_password_policy=LOW;
#修改密码
ALTER USER USER() IDENTIFIED BY 'root';

10.授权所有机器可以访问

grant all privileges on *.* to 'root'@'%' identified by 'root' with grant option;
flush privileges;