Give user-creation privileges to a user

Question

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

hrunting · Accepted Answer · 2013-02-11T00:56:00.830

2

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

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

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.

edited Feb 11 '13 at 00:56

answered Feb 08 '13 at 04:34

hrunting

Thanks. To make it work, I had to specify GRANT CREATE USER ON *.* TO 'username'@'host'... – Steve Bennett Feb 08 '13 at 05:15
I'll edit the answer. – hrunting Feb 08 '13 at 05:41
1

Sorry, that should be `*.*` (star dot star). Stackoverflow ate my asterisks. – Steve Bennett Feb 11 '13 at 00:33

score 1 · Answer 2 · answered Feb 08 '13 at 03:31

1

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.

answered Feb 08 '13 at 03:31

Steve Bennett

Or...I'm totally wrong. I got that from here: http://dev.mysql.com/doc/refman/5.1/en/adding-users.html – Steve Bennett Feb 08 '13 at 05:08

2 Answers2