由于centos7版本的mysql是收费的,所以需要下载rpm包在centos7 上安装mysql服务。
操作系统:win10
虚拟机:64位centos7 linux
1.检查MySQL rpm包安装情况:
rpm -qa | grep mysql
2.删除查询出的mysql5.4相关的包
rpm -e --nodeps mysql包
3.下载mysql源包
wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm
4.安装mysql
yum localinstall mysql57-community-release-el7-8.noarch.rpm
5.设置开机启动mysql服务
systemctl enable mysqld
6.查看安装的mysql:
rpm -aq | grep -i mysql
7.启动mysql服务:
systemctl restart mysqld
8.查看mysql初始密码:
grep 'A temporary password' /var/log/mysqld.log
记下此密码
9.关闭mysql密码强度验证:
编辑配置文件:
vim /etc/my.cnf
在最后添加:
validate_password=off
编辑并保存后重启:
systemctl restart mysqld
10.更改mysql密码:
mysqladmin -u root -p'刚才记下的密码' password '新密码'
11.登录mysql
mysql -u root -p
12.增加用户访问权限:
grant all privileges on *.* to 'root'@'%%' identified by '密码' with grant option;
13.刷新权限:
flush privileges;
14.退出mysql,配置防火墙端口
firewall-cmd --zone=public --add-port=3306/tcp --permanent#打开3306端口
firewall-cmd --reload #不中断服务重新加载
systemctl restart firewalld #重启防火墙
15.使用Navicat测试连接是否成功