CentOS7 配置MySQL57

一、下载

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

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

yum repolist enabled | grep mysql.*

二、安装

yum repolist enabled | grep mysql.*

三、启动

systemctl start  mysqld.service

systemctl status mysqld.service

四、密码

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

mysql -uroot -p

mysql>ALTER USER 'root'@'localhost' IDENTIFIED BY '****************';

五、授权

mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;

mysql>FLUSH PRIVILEGES;

六、自启动

systemctl enable mysqld

systemctl daemon-reload

觉得好，就一键三连呗（点赞+收藏+关注）