How to grant a new user the same direct grant privilege as an existing user in sql

Posted February 18, 2014 1.8k views
There is a new user that just joined our organization. I am trying to grant him the same direct grants privilege to the tables that the existing user has. The existing user has a ton of direct access privileges and it will take days if I had to do each grant one by one like: grant select,insert,delete,update on ttufiscal.pwrpwcm to XKY403. Is there a way of copying or inserting an existing user's privilege and granting it to a new user. Thanks

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Submit an Answer
1 answer
You can use mysqluserclone command from MySQL Utilities here: