Hellas,

I trie to create a user how has the privileges to add new mysql users with the same or less privileges than himself. So I use :

GRANT ALL PRIVILEGES ON dbexample.* TO myUser@"%" IDENTIFIED BY 'some_pass' WITH GRANT OPTION;

But when the user tries to add a user, it says that he has no access to mysql databse. (the grant tables)

Now I wonder if I do anything wrong, or if it is not possible for a non-super user to create a new user and he may only give his privileges to an existing user ?

If so, what are the minimum privileges I have to give a user so he can add new users, and what are the risks ?

Thanks for any help here !

Nobody seems to know anything, poor me