centos7 root 安装mysql5.7

 

  

wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm

 

yum -y install mysql57-community-release-el7-10.noarch.rpm

 

 

yum -y install mysql-community-server

 

 

   启动 重启

  

启动
systemctl start mysqld.service

停止
systemctl stop mysqld.service

重启
systemctl restart mysqld.service

 

第一次需要重置root密码   先启动mysql 在执行下面命令查看临时密码

查看mysql密码 grep "password" /var/log/mysqld.log

 

执行结果

[root@localhost yangjie]# grep "password" /var/log/mysqld.log
2021-01-09T15:09:29.841491Z 1 [Note] A temporary password is generated for root@localhost: Nas&Gpkid2r;

 

登录mysql

mysql -uroot -pNas&Gpkid2r;

 修改密码 错误提示

  

ALTER USER ’root‘@'localhost'  IDENTIFIED BY 'root';

ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

 

使用下面方式修改密码

alter user user() identified by "root";