1、环境介绍
操作系统:centos 7.9
mysql版本:5.7
2、下载yum源
https://dev.mysql.com/downloads/repo/yum/
3、上传yum源文件至服务器,并安装
rpm -Uvh mysql80-community-release-el7-3.noarch.rpm
4、查看支持的mysql版本
yum repolist all | grep mysql
5、安装yum-utils
yum -y install yum-utils
6、切换yum 源为mysql 5.7
yum-config-manager --disable mysql80-community
yum-config-manager --enable mysql57-community
7、安装mysql 5.7
yum install mysql-community-server -y
8、启动mysql server
systemctl start mysqld
systemctl enable mysqld
systemctl status mysqld
9、查看初始密码
grep 'temporary password' /var/log/mysqld.log
10、本地登陆mysql
mysql -uroot -p
输入第九步获得的密码
11、修改本地root用户密码
ALTER USER 'root'@'localhost' IDENTIFIED BY '1qazXSW@';
注意:
MySQL 的 validate_password 插件是默认安装的。这将要求密码至少包含 1 个大写字母、1 个小写字母、1
个数字和 1 个特殊字符,并且密码总长度至少为 8 个字符。
12、建立root远程用户并授权
create user 'root'@'%' identified by '1qazXSW@';
grant all privileges on *.* to 'root'@'%'identified by '1qazXSW@' with grant option;
flush privileges;