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;

Views All Time
Views All Time
1018
Views Today
Views Today
8

2 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

Leave a Reply

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