mysql8.0网络安装教程centos7

1. 安装MySQL Yum Repository

    cd /usr/local/src/
    wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm
    rpm -ivh mysql80-community-release-el7-3.noarch.rpm

2. 查看MySQL版本

    yum repolist enabled | grep "mysql.*-community.*"

3. 安装MySQL

    yum install mysql-community-server

4. 启动MySQL

    systemctl start mysqld

5. 查看MySQL状态

    systemctl status mysqld

6. MySQL安全设置

    mysql_secure_installation

7. 远程连接MySQL

a. 修改MySQL的配置文件/etc/my.cnf，在[mysqld]下添加bind-address=0.0.0.0

    [mysqld]
    bind-address=0.0.0.0

b. 重启MySQL服务

    systemctl restart mysqld

c. 授权远程连接的用户

    GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'yourpassword' WITH GRANT OPTION;
    FLUSH PRIVILEGES;

8. 防火墙设置

a. 查看防火墙状态

    firewall-cmd --state

b. 开放MySQL端口

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

9. 完成安装

至此，MySQL8.0网络安装教程CentOS7已经完成，可以使用MySQL Workbench等客户端连接MySQL服务器了。