CentOS-7 安装MySQL 5.7 （yum源安装）

• 更换源（阿里源）：

curl -o /etc/yum.repos.d/CentOS-Base.repo http://mirrors.aliyun.com/repo/Centos-7.repo

• 安装 MySQL Yum Repository:

  • 下载 MySQL Yum Repository

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

  • 安装 MySQL Yum Repository

    sudo rpm -ivh mysql57-community-release-el7-11.noarch.rpm
    

• 安装 MySQL 5.7:

  • 命令安装 MySQL 5.7

    sudo yum install mysql-community-server
    

  • 启动 MySQL 服务

    systemctl restart mysqld.service
    

  • 检查是否启动成功

    systemctl status mysqld.service
    

  • 查看随机初始密码

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

  • 登录MySQL

    mysql -u root -p
    

  • 修改密码

    ALTER USER 'root'@'localhost' IDENTIFIED BY 'Root123！';（"Root123！"新修改密码，注意新版MySQL密码要求大小写数字加字符）
    

  • 授权其他机器远程登录

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

  • 设置开机自启

    systemctl enable mysqld
    systemctl daemon-reload
    

  • 重启虚拟机

    reboot