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?
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.
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 stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0