mysql8碰到ERROR 1396 (HY000)的解决方案

淡淡的烟草味﹌ 2023-01-12 01:54 292阅读 0赞

mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql\_native\_password BY 'appleyuchi';  
ERROR 1396 (HY000): Operation ALTER USER failed for 'root'@'localhost'  
mysql>   
mysql>   
mysql>   
mysql>   
mysql>   
mysql>   
mysql>   
mysql> flush privileges;  
Query OK, 0 rows affected (0.04 sec)

mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql\_native\_password BY 'appleyuchi';  
ERROR 1396 (HY000): Operation ALTER USER failed for 'root'@'localhost'  
mysql> drop user root@localhost;  
Query OK, 0 rows affected (0.08 sec)

mysql>   
mysql>   
mysql>   
mysql>   
mysql>   
mysql> flush privileges;  
Query OK, 0 rows affected (0.04 sec)

mysql> create user root@localhost identified by 'appleyuchi'  
    -> ;  
Query OK, 0 rows affected (0.07 sec)

mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql\_native\_password BY 'appleyuchi';  
Query OK, 0 rows affected (0.07 sec)

mysql> select host,user,authentication\_string from mysql.user;  
\+-----------+------------------+------------------------------------------------------------------------+  
| host      | user             | authentication\_string                                                  |  
\+-----------+------------------+------------------------------------------------------------------------+  
| %         | flinkuser        | $A$005$2H+Hl3|&bgM;\}8zLe8a9afTbjCFNB6Tar.CVGLYEHJONvqiL5GArGXMA |  
| localhost | debian-sys-maint | $A$005$  
\\'%ew,b;\{9J%eq\`SxxVfK7uOigcQHu7b1KtzChh6u0b7uOTYEbbSNFLFlB |  
| localhost | mysql.infoschema | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED |  
| localhost | mysql.session    | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED |  
| localhost | mysql.sys        | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED |  
**| localhost | root             | \*D3E7FCBA6B5307C86B6EBC7C3BF1DB509167E8F2    **                          |  
\+-----------+------------------+------------------------------------------------------------------------+

alter的时候,如果host和mysql.user中对应不上,

也会导致上述报错.