Mysql 安装

1. mysql普通安装（centos 7.2 + mysql 5.7.26）

• 首先清除本机的Mariadb安装包

  rpm -qa | grep -i mariadb
  rpm -e --nodeps mariadb-libs-5.5.52-1.el7.x86_64
  # 如果安装过mysql，也需要对mysql执行该步骤
  

• 官网找到对应版本的rpm bundle安装包，下载并解压

  wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.26-1.el7.x86_64.rpm-bundle.tar
  tar -xf mysql-5.7.26-1.el7.x86_64.rpm-bundle.tar
  

• 安装依赖库

  yum install -y libaio
  yum install -y net-tools
  

• rpm安装相关包

  rpm -ivh mysql-community-common-5.7.26-1.el7.x86_64.rpm
  rpm -ivh mysql-community-libs-5.7.26-1.el7.x86_64.rpm
  rpm -ivh mysql-community-client-5.7.26-1.el7.x86_64.rpm
  rpm -ivh mysql-community-server-5.7.26-1.el7.x86_64.rpm --force --nodeps
  

• 执行初始化

  mysqld --initialize --user=mysql
  # 再去 /var/log/mysqld.log 寻找到初始密码
  grep -nr "temp" /var/log/mysqld.log
  # 如果出错，或者找不到密码，可以先停止服务，删除/var/lib/mysql 文件夹，并清空mysqld.log重新执行
  

• 启动服务

  # 启动服务
  systemctl start mysqld.service
  # 初始密码进入mysql
  mysql -uroot -p 
  # 修改初始密码
  mysql> alter user 'root'@'localhost' identified by 'newPassword';
  mysql> grant all privileges on *.* to 'root'@'%' identified by 'newPassword' with grant            option;
  mysql> flush privileges;