创建mysql目录
mkdir /usr/local/mysql
进入mysql目录
cd /usr/local/mysql
下载mysql
wget https://repo.mysql.com//mysql80-community-release-el7-1.noarch.rpm
如出现-bash: wget: command not found，执行以下代码
yum -y install wget
wget安装成功
安装mysql
rpm -ivh mysql80-community-release-el7-1.noarch.rpm
更新缓存
yum clean all
yum makecache
查看结果
yum repolist all | grep mysql
执行命令
yum -y install mysql-community-server
如出现以下情况
执行命令
rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
yum -y install mysql-community-server
开启3306端口
firewall-cmd --permanent --add-port=3306/tcp
重启防火墙
firewall-cmd --reload
将mysql 服务加入开机启动项，并启动mysql进程
systemctl enable mysqld.service systemctl start mysqld.service
查看mysql初始密码
cat /var/log/mysqld.log | grep password
账号root 密码 oGwPuJ(su5sa
链接数据库,回车后输入密码 ,然后再回车登录
mysql -uroot -p
登录成功
修改初始密码（默认规则为大写+小写+数字+字符）
ALTER USER 'root'@'localhost' IDENTIFIED BY 'As123qwe!';
设置外部访问
use mysql;
update user set host='%' where user='root';
退出mysql
exit;
重启mysql
service mysqld restart
Navicat链接
如果出现以下情况
链接mysql
修改加密规则
ALTER USER 'root'@'%' IDENTIFIED BY 'As123qwe!' PASSWORD EXPIRE NEVER;
修改密码
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'As123qwe!';
Navicat链接成功
