MySQL8.0授权

mysql> GRANT create,select,insert,update,delete,create,drop,index,alter,execute ON xxxx.* TO xxxx@xxxx;
ERROR 1410 (42000): You are not allowed to create a user with GRANT

报错 不可以授权的方式新建用户
mysql> CREATE USER CCUOT@172.23.48.154 IDENTIFIED BY 'HUNDSUN';
Query OK, 0 rows affected (0.01 sec)

mysql> GRANT create,select,insert,update,delete,create,drop,index,alter,execute ON CCUOT.* TO CCUOT@172.23.48.154;
Query OK, 0 rows affected (0.01 sec)