# CentOs安装mysql

By [海冰](https://paragraph.com/@0xdc8f27bf5782747c336a1befec1d35a20e739718) · 2021-11-13

---

1、下载命令

`wget https://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm`

2、yun源安装命令

`rpm -ivh mysql57-community-release-el7-9.noarch.rpm`

3、使用yum命令安装mysql

`yum -y install mysql-server`

4、启动mysql

`systemctl start mysqld`

5、检查是否安装启动成功

`systemctl status mysqld`

6、查看默认密码

`grep 'temporary password' /var/log/mysqld.log`

7、登录修改密码

`mysql -u root -p`

8、修改密码

因为5.7及以上版本的数据库对密码做了强度要求，默认密码的要求必须是大小写字母数字特殊字母的组合且至少要8位长度

`ALTER USER 'root'@'localhost' IDENTIFIED BY '新的密码';`

    alter user user() identified by "密码";
    

9、允许远程登录

`GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '密码' WITH GRANT OPTION;`

10、如仍然无法访问则需关闭防火墙或者开放3306端口访问权限

附：CentOS 7 关闭防火墙命令

`systemctl stop firewalld.service`

`systemctl disable firewalld.service`

11、查看端口号

    show global variables like 'port';
    

12、查看防火墙状态：

`systemctl status firewalld`

13、开放端口放行：

`firewall-cmd --zone=public --add-port=3306/tcp --permanent`

加上--permanet参数永久生效，如果前面修改了端口号，此处的3306就应改成对应的端口号，然后使用命令重新读取防火墙规则：

`firewall-cmd --reload`

[Centos7离线安装mysql8 https://www.cnblogs.com/quchunhui/p/11115339.html](https://www.cnblogs.com/quchunhui/p/11115339.html)

[https://www.cnblogs.com/blackmanzhang/p/11062817.html](https://www.cnblogs.com/blackmanzhang/p/11062817.html)

[https://www.bilibili.com/video/BV1Cb4y1R7Er](https://www.bilibili.com/video/BV1Cb4y1R7Er?from=search&seid=8676128307902621472&spm_id_from=333.337.0.0)

[https://www.bilibili.com/video/BV1d54y1R7zw](https://www.bilibili.com/video/BV1d54y1R7zw)

---

*Originally published on [海冰](https://paragraph.com/@0xdc8f27bf5782747c336a1befec1d35a20e739718/centos-mysql)*