文章目录
一、 下载并安装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
二、MySQL数据库设置
1.启动mysql
systemctl start mysqld.service
2.查看状态
systemctl status mysqld.service
3.查询默认root密码
grep "password" /var/log/mysqld.log
4.使用默认密码登录root
mysql -uroot -p # 回车后会提示输入密码
5.修改密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'z?guwrBhH7p>';
设置允许使用简单密码
set global validate_password_policy=0;
set global validate_password_length=1;
重新设置你的简单密码(xxxxx按你实际情况)
ALTER USER 'root'@'localhost' IDENTIFIED BY 'xxxxx';
三、卸载Yum Repository
yum -y remove mysql57-community-release-el7-10.noarch
四、允许远程登录(navcat等工具)
grant all on *.* to root@'%' identified by '数据库密码';
安装到此结束啦!!