CentOS使用yum安装mysql5.7

安装指令

wget http://repo.mysql.com/mysql57-community-release-el7-8.noarch.rpm

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

yum -y install mysql-server
 

启动MySQL

systemctl start mysqld.service

查看服务是否启动成功

systemctl status mysqld.service

获取默认的MySQL root 密码

grep "password" /var/log/mysqld.log

登录mysql

    mysql -u root -p

修改root密码

alter user 'root'@'localhost' identified by 'xxx';

让mysql接收设置简单的密码

show variables like 'validate_password%';
set global validate_password_policy=0;
set global validate_password_length=1;

修改root账户密码为简单密码

alter user 'root'@'localhost' identified by '123456';

远程访问账户的创建、授权

create user 'xxx' identified by 'xxx';
GRANT ALL PRIVILEGES ON *.* TO 'xxx'@'%' IDENTIFIED BY 'xxx' WITH GRANT OPTION;
flush privileges;

防火墙开启3306端口

firewall-cmd --list-all
firewall-cmd --permanent --add-port=3306/tcp
service firewalld restart
firewall-cmd --query-port=3306/tcp
firewall-cmd --list-all

至此安装结束，可以开始使用mysql5.7了。