Database Administration (MOSC)

MOSC Banner

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center