mysql8 GRANT user

mysql> CREATE USER 'mike'@'%' IDENTIFIED BY '000000';

 

mysql> GRANT ALL ON *.* TO 'mike'@'%' WITH GRANT OPTION;

 

错误:

Authentication to host 'localhost' for user 'root' using method 'mysql_native_password' failed