linux 安装mysql5.7

1 下载并安装MySQL官方的 Yum Repository

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

yum -y install mysql57-community-release-el7-10.noarch.rpm
先执行:yum module disable mysql
# wget http://centos.ustc.edu.cn/centos/RPM-GPG-KEY-CentOS-5
# rpm --import RPM-GPG-KEY-CentOS-5
再执行:yum -y install mysql-community-server

systemctl start mysqld.service
systemctl status mysqld.service
此时MySQL已经开始正常运行,不过要想进入MySQL还得先找出此时root用户的密码,通过如下命令可以在日志文件中找出密码:
grep "password" /var/log/mysqld.log 
mysql -uroot -p
ALTER USER 'root'@'localhost' IDENTIFIED BY 'new password';

以下操作是为方便远程连接
use mysql;
update user set host = '%' where user ='root';
flush privileges;



 


posted @ 2020-10-27 13:48  浮生逍遥  阅读(62)  评论(0编辑  收藏  举报