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中对应不上,
也会导致上述报错.