ERROR 1410 (42000): You are not allowed to create a user with GRANT
The environment is redhat 7.8 version, mysql 8.0.28 version.
When you connect to mysql as a user with root privileges and run the command below,
GRANT DROP ON wooriinfo_push.* TO DLSBAT@% WITH GRANT OPTION;
The following error occurs:
ERROR 1410 (42000): You are not allowed to create a user with GRANT
The DLSBAT account was created, and the above error occurred during the authorization process.
To resolve this, if I give % (external permissions) to root and run the command again, the error does not occur. I am curious about the cause of this and whether there are any related bugs.
Thanks for reading.