目录
一、下载MySQL文件
wget https://repo.mysql.com//mysql80-community-release-el7-1.noarch.rpm
二、安装MySQL
1.安装mysql
rpm -ivh mysql80-community-release-el7-1.noarch.rpm
2.重新建立元数据缓存
yum clean all && yum makecache
3.更新密钥
rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
4.安装mysql-community-server
yum install -y mysql-community-server
5.查看安装结果
yum repolist all | grep mysql
三、启动并设置开机自启动
systemctl enable mysqld.service && systemctl start mysqld.service
四、开启端口
1.开启3306端口
firewall-cmd --add-port=3306/tcp --permanent
2.重启防火墙
firewall-cmd --reload
五、设置外部访问
1.查看mysql初始密码
cat /var/log/mysqld.log | grep password
账号root 密码 oGwPuJ(su5sa
2.链接数据库
mysql -uroot -p
3.修改初始密码(默认规则为大写+小写+数字+字符)
ALTER USER 'root'@'localhost' IDENTIFIED BY 'As123qwe!';
4.设置外部访问
use mysql;
update user set host='%' where user='root';
5.退出mysql
exit;
6.重启mysql
service mysqld restart
六、Navicat链接
如果出现以下情况
链接mysql
mysql -uroot -p
修改加密规则
ALTER USER 'root'@'%' IDENTIFIED BY 'As123qwe!' PASSWORD EXPIRE NEVER;
修改密码
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'As123qwe!';
Navicat链接成功