CentOS7安装MySQL
1、检查系统是否安装了mariadb,如果安装了要先卸载
# 检查是否安装mariadb
rpm -qa | grep mariadb # 卸载 mariadb rpm -e --nodeps mariadb-libs-5.5.68-1.el7.x86_64
2、下载mysql
wget https://repo.mysql.com/mysql80-community-release-el7-6.noarch.rpm
3、安装
yum install mysql80-community-release-el7-6.noarch.rpm
4、重新获取GPG密钥,否则安装“mysql-community-server”会报“获取 GPG 密钥失败”的错误
rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
5、安装 mysql-community-server
yum -y install mysql-community-server
6、设置MySQL服务开机启动
systemctl start mysqld.service
7、查看MySQL初始密码,并登录MySql
cat /var/log/mysqld.log | grep password
mysql -u root -p
8、修改root登录密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'Aa_123456';
修改密码之后退出登录,然后用新密码登录,能登录成功表示密码修改成功。
9、设置远程连接
①:修改mysql数据库中user表的host的值为“%”,然后刷新权限
update user set host = '%' where user = 'root'; select user,host from user; flush privileges;
②:在防火墙开放3306端口
systemctl start firewalld firewall-cmd --state firewall-cmd --permanent --add-port=3306/tcp firewall-cmd --reload
③:用MySQL客户端测试连接
参考:
centOS7安装MySQL教程 - 魔幻小生 - 博客园 (cnblogs.com)