MySql8.0.19最新版本创建用户分配权限演示，You have an error in your SQL syntax权限分配问题解决方法

mysql> grant all privileges on sonar_scan.* to 'sonar'@'%' identified by '123456
a';
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 'ident
ified by '123456a'' at line 1

mysql> grant all privileges on sonar_scan.* to 'sonar'@'%';
Query OK, 0 rows affected (0.24 sec)

mysql> grant all privileges on sonar_scan.* to 'sonar'@'%';
Query OK, 0 rows affected (0.24 sec)

mysql> grant all privileges on sonar_scan.* to 'sonar'@'localhost';
ERROR 1410 (42000): You are not allowed to create a user with GRANT

mysql>  update user set host='localhost' where user='sonar';
Query OK, 1 row affected (0.53 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> update user set host='localhost' where user='sonar';
ERROR 1046 (3D000): No database selected
mysql> use mysql;
Database changed

mysql>  update user set host='localhost' where user='sonar';
Query OK, 1 row affected (0.53 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> create database sonar_scan default character set utf8 collate utf8_genera
l_ci;
Query OK, 1 row affected, 2 warnings (0.19 sec)

mysql> create user 'sonar' identified by '123456a';
Query OK, 0 rows affected (0.11 sec)

mysql> grant all privileges on sonar_scan.* to 'sonar'@'%';
Query OK, 0 rows affected (0.24 sec)