mysql5.7

• 安装

  • 下载mysql yum源
    wget https://dev.mysql.com/get/mysql57-community-release-el6-9.noarch.rpm
  • 安装yum源
    yum localinstall mysql57-community-release-el6-9.noarch.rpm
    yum install mysql-community-server

• 启动
  service mysqld start

  但是这里不知道mysql的root用户的登录密码
  需要进入/etc/my.cnf的mysql配置文件中，找到log-error=/var/log/mysqld.log

  A temporary password is generated for root@localhost: +Vxzn,0Y7,fj
  

• 密码修改

  mysql>  alter user 'root'@'localhost' identified by 'root';
  ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
  

• 数据库备份

  # 备份mysql数据库到本地
  mysqldump -uroot -p mysql > /opt/datas/mysqlbak.sql