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.
MySQL:
- https://dev.mysql.com/doc/refman/8.0/en/roles.html
- https://dev.mysql.com/doc/refman/8.0/en/create-role.html
MariaDB:
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