mysql临时密码不能用_mysql5.7.初始化后，临时密码过期-优快云博客

本文链接：https://blog.youkuaiyun.com/weixin_42361623/article/details/113166618

root@localhost [(none)]>use mysql

Reading table informationforcompletion of table and column names

You can turn offthis feature to get a quicker startup with -A

Database changed

root@localhost [mysql]>select * from user where user='root'\G;*************************** 1. row ***************************Host: localhost

User: root

Select_priv: Y

Insert_priv: Y

Update_priv: Y

Delete_priv: Y

Create_priv: Y

Drop_priv: Y

Reload_priv: Y

Shutdown_priv: Y

Process_priv: Y

File_priv: Y

Grant_priv: Y

References_priv: Y

Index_priv: Y

Alter_priv: Y

Show_db_priv: Y

Super_priv: Y

Create_tmp_table_priv: Y

Lock_tables_priv: Y

Execute_priv: Y

Repl_slave_priv: Y

Repl_client_priv: Y

Create_view_priv: Y

Show_view_priv: Y

Create_routine_priv: Y

Alter_routine_priv: Y

Create_user_priv: Y

Event_priv: Y

Trigger_priv: Y

Create_tablespace_priv: Y

ssl_type:

ssl_cipher:

x509_issuer:

x509_subject:

max_questions:0max_updates:0max_connections:0max_user_connections:0plugin: mysql_native_password

authentication_string:*7C9CB2A4F227FF764C10705941B03E2B1C378AF1

password_expired: Y

password_last_changed:2020-01-14 10:08:12password_lifetime: NULL

account_locked: N1 row in set (0.00sec)

ERROR: No query specified

root@localhost [mysql]>update user set password_expired='N' where user='root';

Query OK,1 row affected (0.09sec)

Rows matched:1 Changed: 1 Warnings: 0root@localhost [mysql]>select * from user where user='root'\G;*************************** 1. row ***************************Host: localhost