Tweeted twitter.com/StackDBAs/status/784779128675373056
3 minor punctuation correction
source | link

For our software we need a MySQL user who is able to create other MySQL users. This is possible 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 that you have.

Maybe I understand something wrong but I'm afraid to do something wrong on our server. That's also the reason for my question.

I hope someone can explain to me if it's possible, and how, to create a user with the privileges we need.

For our software we need a MySQL user who is able to create other MySQL users. This is possible 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 that you have.

Maybe I understand something wrong but I'm afraid to do something wrong on our server. That's also the reason for my question.

I hope someone can explain to me if it's possible and how to create a user with the privileges we need.

For our software we need a MySQL user who is able to create other MySQL users. This is possible 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 that you have.

Maybe I understand something wrong but I'm afraid to do something wrong on our server. That's also the reason for my question.

I hope someone can explain to me if it's possible, and how, to create a user with the privileges we need.

2 added relevan t tags, removed a tag from the title, corrected grammar/spelling, removed noise
source | link

Create a MySQL user with privileges to create MySQL users

For our software we need a MySQL user who is able to create other MySQL users. This is posiblepossible 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 iI check the mysqlMySQL 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." soSo provides not the option to create users, only give them permissions whatthat you have....

Maybe iI understand something wrong but iI'm afraid to do something wrong on our server. ThatsThat's also athe reason for my question...

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

Thanks a lot in advance!

Create a MySQL user with privileges to create MySQL users

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!

Create a user with privileges to create users

For our software we need a MySQL user who is able to create other MySQL users. This is possible 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 that you have.

Maybe I understand something wrong but I'm afraid to do something wrong on our server. That's also the reason for my question.

I hope someone can explain to me if it's possible and how to create a user with the privileges we need.

1
source | link

Create a MySQL user with privileges to create MySQL users

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!