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

If you have some issue on MySQL 8 database:

CREATE USER 'user'@'localhost' IDENTIFIED BY 'root';
GRANT ALL PRIVILEGES ON user.* TO 'user'@'localhost' WITH GRANT OPTION;

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

  1. Rocky

    After creating a user, when I want to grant it previlege, I face this mesage:
    ERROR 1410 (42000): You are not allowed to create a user with GRANT

    Reply
      1. Samuel

        Thanks for this, but if i want to revoke delete, drop and trigger for the created user, which command i must use?

        Reply

Leave a Reply

Your email address will not be published. Required fields are marked *