Activities

August 2016
M T W T F S S
« Jul   Nov »
1234567
891011121314
15161718192021
22232425262728
293031  

MySQL : How to create multiple root user (Super admin)

I have a situation to create multiple root users for managing a large Database. I used to execute ‘ grant all *. user@localhost identified by ‘password’ ” to create super users earlier. But I realized that these users can’t alter the existing users permission set even though they can create same privilege set users.

Knowing that this is a rare case in most of the scenario where no. of DBA are very limited. So one of my collegue found that we need to opt “with grant option” while you creating multiple super root users.

So that you will have FULL access to MySQL user accounts. Amazon RDS service will automatically create such user when you turn out an new RDS instance. But they did not allow you to create ‘super root‘ users sadly 🙁

Solution :

GRANT ALL PRIVILEGES ON *.* TO 'user'@'localhost' IDENTIFIED BY 'password'
WITH GRANT OPTION;

Leave a Reply

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>