# 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> //連接成功
設置新密碼
mysql>set password = '123456';
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> set password='123456';
Query OK, 0 rows affected (0.00 sec)
//設置成功
允許遠程登陸
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)
