CentOS7 安装 mysql5.7

CentOS 7 安装 Mysql 5.7

1. 先清除预装的mariadb或mysql

   # 使用rpm卸载可能预装的mysql和mariadb
   rpm -aq | grep -iE 'mariadb|mysql' | xargs rpm -e --nodeps
   rm -rf `find / -name mysql`
   rm -rf `find / -name my.cnf`
   

2. 下载mysql5.7 rpm安装包，下载地址

   选择操作系统 Red Hat Enterprise Linux / Oracle Linux

   选择操作系统版本 Red Hat Enterprise Linux 7 / Oracle Linux 7 (x86, 64-bit)

   

   下载如下几个包

   
   
   
   
   

   也可以使用wget工具下载

   wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-community-server-5.7.38-1.el7.x86_64.rpm
   wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-community-client-5.7.38-1.el7.x86_64.rpm
   wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-community-common-5.7.38-1.el7.x86_64.rpm
   wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-community-libs-5.7.38-1.el7.x86_64.rpm
   wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-community-libs-compat-5.7.38-1.el7.x86_64.rpm
   

3. 安装mysql

   rpm安装mysql，注意，把上面下载的 五个 rpm安装包放到一个目录下并cd进入

   

   执行安装指令

   ls | grep -iE 'mysql-community-.+?\x86_64.rpm' | xargs rpm -ivh --nodeps
   

   

   这样就安装完成了

4. 启动mysqld并查看初始化的临时密码

   # 启动mysql
   systemctl start mysqld
   # 查看临时密码
   grep 'temporary password' /var/log/mysqld.log
   # 登录mysql
   mysql -uroot -p'临时密码'
   

   

   设置永久密码

   ### 以下在数据库命令行操作
   # mysql5.7 密码长度要求8位以上包含英文大小写数字和符号
   # 设置密码
   alter user user() identified by 'Test1234..';
   # 刷新权限
   flush privileges;
   # 退出数据库
   exit;
   

   

   记得使用永久密码测试登录一下mysql哦

5. 补充操作

   # 启动数据库
   systemctl start mysqld
   # 停止数据库
   systemctl stop mysqld
   # 重启数据库
   systemctl restart mysqld
   # 查看数据库状态
   systemctl status mysqld