快速在线安装mysql5.7

在线安装

安装mysql安装源

下载安装包

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

安装MySQL源

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

安装mysql

yum -y install mysql-community-server --nogpgcheck

启动 mysql 服务

systemctl start mysqld

设置开机启动（可选）

systemctl enable mysqld
systemctl daemon-reload

查看生成的临时密码

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

登录

mysql -u root -p

USE mysql;

修改密码

ALTER USER 'root'@'localhost' IDENTIFIED BY '新密码';

修改本地登录为允许远程连接

UPDATE user SET host='%' WHERE user='root' AND host='localhost';

刷新配置

FLUSH PRIVILEGES;

退出

exit;