centos yum 安装mysql：5.7

安装mysql

1. 进入到yum安装目录（可选）
   cd /opt/yum
2. 下载yum 源 rpm 安装包
   wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm
3. 安装mysql 源
   yum localinstall mysql80-community-release-el7-3.noarch.rpm -y
4. 查询一下mysql 源是否安装成功
   yum repolist enabled | grep "mysql.*-community.*"
   
   查询所有版本
   yum repolist all | grep mysql
5. 禁用8.0
   yum-config-manager --disable mysql80-community
   若提示可执行yum -y install yum-utils安装工具
6. 启用5.7
   yum-config-manager --enable mysql57-community
7. 验证是否启用成功
   yum repolist enabled | grep mysql
8. 安装mysql
   yum install -y mysql-community-server
9. 启动mysql
   systemctl start mysqld

mysql 初始化设置

1. 设置mysql开机自启
   systemctl enable mysqld
2. 查询mysql初始密码，存在于文件/var/log/mysqld.log(需要先启动服务才会生成密码，否则文件为空)
   grep 'temporary password' /var/log/mysqld.log
3. 通过拿到密码登录mysql
   mysql -uroot -p 输入密码
4. 修改密码
   ALTER USER 'root'@'localhost' IDENTIFIED BY '新密码';
   （新密码必须包含大写字母、小写字母、数字、标点符号，且密码长度至少为 8）
5. 设置远程连接
   GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'GUAmapi@940' WITH GRANT OPTION;
   刷新权限：FLUSH PRIVILEGES;

配置文件

• 配置文件在：/etc/my.cnf