Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

2 Answers 2

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
1  
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: dev.mysql.com/doc/refman/5.1/en/adding-users.html –  Steve Bennett Feb 8 '13 at 5:08

Your Answer

 
discard

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.