mysql80远程连接ERROR 1410 (42000): You are not allowed to create a user with GRANT 更改权限报错。

ERROR 1410 (42000): You are not allowed to create a user with GRANT

更改权限报错。

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password by 'password';
flush privileges;

mysql> ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password;
Query OK, 0 rows affected (0.01 sec)

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

mysql> select user,host,default_authentication_plugin from user;
ERROR 1054 (42S22): Unknown column 'default_authentication_plugin' in 'field list'
mysql> select user,host,default_authentication_plugin from user;
ERROR 1054 (42S22): Unknown column 'default_authentication_plugin' in 'field list'
mysql> select user,host,plugin from user;
+------------------+-----------+-----------------------+
| user             | host      | plugin                |
+------------------+-----------+-----------------------+
| root             | %         | mysql_native_password |
| mysql.infoschema | localhost | caching_sha2_password |
| mysql.session    | localhost | caching_sha2_password |
| mysql.sys        | localhost | caching_sha2_password |
| root             | localhost | caching_sha2_password |
+------------------+-----------+-----------------------+
5 rows in set (0.00 sec)

mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password;
Query OK, 0 rows affected (0.01 sec)

mysql> flush privileges;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
mysql> ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password by 'password.';
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
mysql> flush privileges;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
mysql> use mysql
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
mysql> quit();
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'quit()' at line 1
mysql> q;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'q' at line 1
mysql> exit;
Bye
[root@localhost sysconfig]# mysql -uroot -p
Enter password: 
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
[root@localhost sysconfig]# mysql -uroot -p
Enter password: 
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
[root@localhost sysconfig]# mysql -uroot@localhost -p
Enter password: 
ERROR 1045 (28000): Access denied for user 'root@localhost'@'localhost' (using password: YES)
[root@localhost sysconfig]# 
[root@localhost sysconfig]# mysql -uroot -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 31
Server version: 8.0.16

Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> grant all privileges on *.* to 'root'@'%' identified by 'password';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'identified by 'password.'' at line 1
mysql> ALTER USER 'root'@'localhost' IDENTIFIED  BY 'password';
Query OK, 0 rows affected (0.00 sec)

mysql> ALTER USER 'root'@'%' IDENTIFIED WITH  BY 'password.';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'BY 'password'' at line 1
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)