注:因为centos8已经停止维护了,所以yum已经没用了
这就需要先cd到/etc/yum.repos.d/下面
cd /etc/yum.repos.d/
然后把yum下载的后台从http://mirror.centos.org改成http://vault.centos.org
先要修改CentOS-Linux-BaseOS.repo:
还要修改CentOS-Linux-AppStream.repo:
1. yum安装wget
yum install -y wget
2. wget获取mysql官方的yum repository
wget https://repo.mysql.com//mysql80-community-release-el7-1.noarch.rpm
3. 安装repo
rpm -ivh mysql80-community-release-el7-1.noarch.rpm
4. yum安装mysql-server
yum install mysql-server
5. 启动mysql
systemctl start mysqld.service
6. 用mysqladmin修改root的密码
mysqladmin -u root password "newpassword"
7. 登录root进入mysql
mysql -uroot -pnewpassword
8. 关闭防火墙,打开3306,允许外部访问
systemctl stop firewalld
firewall-cmd --permanent --zone=public --add-port=3306/tcp
firewall-cmd --reload
9. 修改mysql库里面user表中root的host字段为%,这样可以让navicat连接
use mysql;
update user set host='%' where user='root';
flush privileges;
记得加 ';'
10. 配置navicat连接
记得要在连数据库之前加个ssh
然后再加数据库
连接成功