CentOS7安装mysql5.7

卸载自带的mariadb

#卸载Centos7.9自带的mariadb并删除相关目录及文件find / -iname mysql*
yum -y remove mariadb-*
rm -rf /etc/selinux/targeted/active/modules/100/mysql
rm -rf /usr/lib/firewalld/services/mysql.xml
rm -rf /usr/lib64/mysql

安装mysql5.7

#下载mysql5.7yum源
wget https://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm
#安装mysql5.7的yum源
rpm -ivh mysql57-community-release-el7-9.noarch.rpm
#安装mysql5.7，安装前导入密钥，不然报错mysql-community-server-5.7.37-1.el7.x86_64.rpm 的公钥尚未安装
rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
yum -y install mysql-server
#启动mysql服务，并设置为开机自启
systemctl start mysqld
systemctl enable mysqld

初始化mysql

#1.查看mysql初始密码
grep 'temporary password' /var/log/mysqld.log | cut -d " " -f11
#2.执行初始化
mysql_secure_installation

按照如下设置即可

配置mysql的root用户可被远程访问

#配置远程访问
mysql -uroot -p初始化时设置的新密码<<EOF
grant all privileges on *.* to 'root' @'%' identified by "初始化时设置的新密码";
flush privileges;
EOF
#验证是否可远程访问
mysql -h192.168.42.201 -uroot -p