How can I give CREATE USER and GRANT privileges to an user in MySQL?

Question

I created a new user called Hamza in localhost then I tried to give it these 2 privileges:

CREATE USER
GRANT

For the creation everything is OK, but when it comes to granting the privileges I tried this query :

GRANT CREATE USER TO 'Hamza'@'localhost' WITH GRANT OPTION;

And I got this error :

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TO 'Hamza'@'localhost' WITH GRANT OPTION' at line 1

Could someone tell me how can I correct this syntax error ?

Rahul · Accepted Answer · 2015-06-25 18:52:13Z

1

You are missing the ON object_name here in your GRANT statement like

GRANT CREATE USER ON *.* TO 'Hamza'@'localhost' WITH GRANT OPTION;

answered Jun 25, 2015 at 18:52

Rahul

78.1k14 gold badges80 silver badges132 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How can I give CREATE USER and GRANT privileges to an user in MySQL?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related