Centos7在线安装部署mysql5.7

安装mysql

 yum -y install mysql-community-server

出现以下错误，则需先安装依赖

安装依赖

 //下载依赖
 wget https://repo.mysql.com//mysql57-community-release-el7-11.noarch.rpm
 //安装依赖
 rpm -ivh mysql57-community-release-el7-11.noarch.rpm

再次安装mysql服务

  //安装服务
  yum install mysql-community-server -y
  //启动服务
  systemctl start mysqld
  //添加开机启动
  systemctl enable mysqld

查看root默认密码

   more /var/log/mysqld.log 

如下图查看root默认密码

修改密码

登录mysql

 mysql -u root -p

修改密码

 ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';

出现以下错误需先修改规则

 //修改密码规则参数
 set global validate_password_policy=0; 
 set global validate_password_length=1;

再次修改密码

  ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';

授权访问权限

  //授权访问权限
  GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
  //刷新缓存
  FLUSH  PRIVILEGES;