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

Time:09-26

Use the root account login

Mysql>
Mysql> The CREATE USER 'leven' @ 'localhost' IDENTIFIED BY 'Az12345678! ';
Query OK, 0 rows affected (0.04 SEC)

Mysql>
Mysql> TO GRANT the REPLICATION SLAVE ON *. * 'leven' @ '%';
ERROR 1410 (42000) : You are not allowed to create a user with GRANT


This is what reason, not familiar with mysql, thank you

CodePudding user response:

'leven' @ 'localhost' and 'leven' @ '%'; Is not the same user account,
In addition you don't have permission to create users through GRANT, show grants; check your permissions
  • Related