My task is simple i want to create a user in MySQL server that has all the privileges but excluding the ability to create other users.
I tried to create a user through the root account. then i gave him all the privileges, then i revoked the 'create user' privilege from this new user, then i 'flushed privileges'. i thought this is would be enough but when i logged in with the new user, i was able to create another user.
these are the codes that i used in my root account to create a new user and give him privileges except for the 'create user' privilege:
create user 'user91'@'localhost' identified by 'google';
grant all privileges on *.* to 'user91'@'localhost';
revoke create user on *.* from 'user91'@'localhost';
After this i logged out of the root account and signed in with the 'user91' account and tried to create another user with this code:
create user 'slim2000'@'localhost' identified by 'stealth';
and this code worked, what should i add in the first block of code in order to prevent 'user91' from creating other users.