前期准备
(1)MySQL安装包:
链接:https://pan.baidu.com/s/1beldwvkOZIeNc3E8rhv4ag
提取码:yyds
(2)在/opt/下创建software文件夹,把下载好的MySQL包上传到该目录下;
[root@master3 ~]# mkdir /opt/software
[root@master3 ~]# cd /opt/software/
安装MySQL
(1)解压tar文件;
[root@master3 software]# tar -xvf mysql-5.7.31-1.el7.x86_64.rpm-bundle.tar
(2)删除冲突的mariadb组件;
[root@master3 software]# rpm -qa|grep mariadb
[root@master3 software]# yum remove -y mariadb*
(3)进入software文件夹,安装MySQL组件;
[root@master3 software]# yum localinstall -y *
(4)开启MySQL服务,查看服务状态;
[root@master3 software]# systemctl start mysqld
[root@master3 software]# systemctl status mysqld
(5)查看MySQL初始密码;
[root@master3 software]# cat /var/log/mysqld.log | grep password
(6)输入初始密码登录MySQL;
[root@master3 software]# mysql -uroot -pv.H55YAuT+Sd
(7)关闭密码复杂性策略、设置密码复杂性要求密码最低长度为1
mysql> set global validate_password_policy=0;
mysql> set global validate_password_length=1;
(8)MySQL设置新密码;
mysql> set password=password('123456');
(9)MySQL赋权:'root'@'%' 权限赋给root用户,所有IP都能连接;
mysql> grant all privileges on *.* to 'root'@'%' identified by '123456';
(10)刷新权限;
mysql> flush privileges;
测试MySQL登录;
[root@master3 software]# mysql -uroot -p123456