grep “temporary password” /var/log/mysqld.log
# grep “temporary password” /var/log/mysqld.log
2019-11-22T15:39:47.315529Z 1 [Note] A temporary password is generated for root@localhost: _Ow,eqT,c7pa
然后可以设置新密码:
SET PASSWORD = PASSWORD(“root”);
grep “temporary password” /var/log/mysqld.log
# grep “temporary password” /var/log/mysqld.log
2019-11-22T15:39:47.315529Z 1 [Note] A temporary password is generated for root@localhost: _Ow,eqT,c7pa
然后可以设置新密码:
SET PASSWORD = PASSWORD(“root”);