Create new MySql user with same grants as existing user

The question:

To create a new user usr_B with same grants as an existing user usr_A we can always SHOW GRANTS for usr_A and then GRANT those privileges to usr_B, but is there a built-in command for this purpose?

The Solutions:

Below are the methods you can try. The first solution is probably the best. Try others if the first one doesn’t work. Senior developers aren’t just copying/pasting – they read the methods carefully & apply them wisely to each case.

Method 1

Rather than copying the grants over, consider creating a “role” with suitable privileges. Then GRANT a role TO a user.



All methods was sourced from or, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0

Leave a Comment