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

1. Rocky June 19, 2019 at 6:25 am

   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. Vitalijus Ryzakovas Post authorJune 20, 2019 at 7:50 am

      Try:

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

      Reply ↓
      1. Samuel October 20, 2023 at 3:25 am

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

         Reply ↓