# mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
//獲取初始密碼
# cat /var/log/mysqld.log | grep 'password'
2017-09-20T06:16:07.973662Z 1 [Note] A temporary password is generated for root@localhost: DfqamzHdl7_N //DfqamzHdl7_N就是初始密碼
//連接mysql
# mysql -u root -p
Enter password: DfqamzHdl7_N
mysql> //連接成功
設(shè)置新密碼
mysql>set password = '123456';
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
//這是因?yàn)槌跏济艽a等級(jí)設(shè)置有點(diǎn)高省容，可以設(shè)低點(diǎn)
mysql> set global validate_password_policy=0;
Query OK, 0 rows affected (0.00 sec)
mysql> set global validate_password_length=1;
Query OK, 0 rows affected (0.00 sec)
mysql> set password='123456';
Query OK, 0 rows affected (0.00 sec)
//設(shè)置成功
允許遠(yuǎn)程登陸
mysql>use mysql;
Database changed
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
mysql> set global validate_password_policy=0;
Query OK, 0 rows affected (0.00 sec)
mysql> set global validate_password_length=1;
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
Query OK, 0 rows affected, 1 warning (0.00 sec)
