Centos6.9 安装mysql5.7

[w3eee]

• 删除系统自带mysql5.1 如果安装的话
  yum list installed | grep mysql
yum -y remove mysql-libs.x86_64

• 下载并安装源
  wget dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm
yum localinstall mysql-community-release-el6-5.noarch.rpm
yum repolist all | grep mysql # 查看启用情况

• 启用mysql57
  vim /etc/yum.repos.d/mysql-community.repo # 将57的enabled改成1, 56的改成0

• 安装并启动服务
  yum install mysql-community-server
service start mysqld

• 配置
  grep 'temporary password' /var/log/mysqld.log # 查看临时密码
  mysql -uroot -p # 使用临时密码登录
  ALTER USER 'root'@'localhost' IDENTIFIED BY 'Mdfd@ddwPass2!'; # 修改密码

  配置文件位于 /etc/my.cnf

• 添加用户
  create user test identified by 'test';
grant all privileges on xxdb.* to test@'%' identified by 'test';
flush privileges;