大数据学习第二天：修改mysql 默认密码(centos7)

1查看mysql默认密码：

[root@hadoop usr]# sudo grep 'temporary password' /var/log/mysqld.log

2017-09-28T15:46:32.604637Z 1 [Note] A temporary password is generated for root@localhost: 0+SFwD(i_;wg

2：用默认密码登陆：

[root@hadoop usr]# mysql -uroot -p
Enter password: 0+SFwD(i_;wg

3：设置密码级别

mysql> set global validate_password_policy=0;
Query OK, 0 rows affected (0.00 sec)


mysql> set global validate_password_length=4;
Query OK, 0 rows affected (0.00 sec)

4：修改密码：

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'root';
Query OK, 0 rows affected (0.00 sec)

此时账号为:root,密码：root