Administrator
发布于 2021-12-27 / 297 阅读
0
0

Centos7-yum安装MySQL5.7

Centos7-yum安装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 -y install mysql-community-server

2.MySQL数据库设置

#首先启动MySQL
systemctl status mysqld.service

#通过如下命令在日志文件中找出密码
grep "password" /var/log/mysqld.log

#进入数据库
mysql -uroot -p

#修改数据库密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'new password';

#卸载Yum Repository,防止每次yum操作自动更新
yum -y remove mysql57-community-release-el7-10.noarch

#对用户授权
grant all on *.* to root@'%' identified by '数据库密码';

#刷新权限
flush privileges;

评论