For our software we need a MySQL user who is able to create other MySQL users. This is posible with the MySQL root user but we do not want to use the root user in our software application. Is there a way to create a MySQL user which can create other users?

I read multiple topics and pages on the internet which say it is possible with the GRANT OPTION. But when i check the mysql permission description, this permission is "The GRANT OPTION privilege enables you to give to other users or remove from other users those privileges that you yourself possess." so provides not the option to create users, only give them permissions what you have....

Maybe i understand something wrong but i afraid to do something wrong on our server. Thats also a reason for my question...

I hope someone can explain me if it s posible and how to create a user with the privileges we need and take my afraidnes...

Thanks a lot in advance!