Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

In MySQL, how do you allow another user to create other users? In turn, those users should only be able to view some tables.

share|improve this question
up vote 2 down vote accepted

From MySQL's privileges documentation, the CREATE USER privilege is the one you want:

GRANT CREATE USER ON *.* TO 'username'@'host'

For other privileges, read MySQL's GRANT documentation.

Note, I've linked to MySQL 5.0 documentation. GRANT hasn't changed much over the years, so any newer versions should also use the same syntax.

share|improve this answer
Thanks. To make it work, I had to specify GRANT CREATE USER ON . TO 'username'@'host'... – Steve Bennett Feb 8 '13 at 5:15
I'll edit the answer. – hrunting Feb 8 '13 at 5:41
Sorry, that should be *.* (star dot star). Stackoverflow ate my asterisks. – Steve Bennett Feb 11 '13 at 0:33

I think the answer is this:

GRANT INSERT on mysql.* to 'username';
GRANT RELOAD on *.* TO 'username'@'%';

Plus setting grant access on the relevant tables.

share|improve this answer
Or...I'm totally wrong. I got that from here: – Steve Bennett Feb 8 '13 at 5:08

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.