【centos】安装MySQL 5.7

1、下载安装

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 && rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022 && yum -y install mysql-community-server

2、开启mysql服务

systemctl start mysqld.service

3、查看mysql默认密码、登录、修改密码、其他设置

cat /var/log/mysqld.log | grep password
grep "password" /var/log/mysqld.log | cut -f2 -d@ | awk '{print $2}' # 用这行直接看密码
mysql -uroot -p
# 修改密码
SET PASSWORD FOR 'root'@'localhost' = '新的密码，不可以是弱密码，要用单引号包起来';
# 开启mysql的远程访问 %代表所有IP
grant all privileges on *.* to 'root'@'%' identified by '你的密码，有引号' with grant option;
flush privileges; 
exit;

主机开放3306端口

# 系统开放3306的访问
firewall-cmd --zone=public --add-port=3306/tcp --permanent
firewall-cmd --reload

测试一下能不能用

能连上了