mysqlsqlmariadb

What difference does WITH GRANT OPTION make?

I want to create a standard MySQL user but I couldn't understand the difference on between of these two statements.

1 -> GRANT ALL ON *.* TO user@host WITH GRANT OPTION;
2 -> GRANT ALL ON *.* TO user@host;

Which one should I use for a standard user and what is the effect of the "WITH GRANT OPTION" to the creating a user?

Solution

  • ALL does not include WITH GRANT OPTION. WITH GRANT OPTION allows the user to perform GRANT for other users.