Home / server / Questions / 476713
Accepted
Steve Bennett
Asked: 2013-02-08 19:31:12 +0800 CST

Give user-creation privileges to a user

  • 772

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

mysql

2 Answers

  1. Best Answer

    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.

    • 2

  2. 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.

    • 1