MySQL5.7安装部署

MySQL5.7部署安装

linux CentOS7.9

下载安装Yum镜像

sudo rpm -Uvh mysql80-community-release-el7-3.noarch.rpm

查看yum列表（ALL）

yum repolist all | grep mysql

禁用mysql80、启用mysql57

sudo yum-config-manager --disable mysql80-community
sudo yum-config-manager --enable mysql57-community

查看启用的yum列表

yum repolist enabled | grep mysql

下载mysql

sudo yum install mysql-community-server

启动服务

systemctl start mysqld

查看服务状态

systemctl status mysqld

查看初始化密码

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

登录mysql

mysql -u root -p

更改密码

ALTER USER 'root'@'localhost' IDENTIFIED BY 'password';