3.2.3 Creating a New User With The Same Privileges as Another User

3.2.3.1 Objectives
3.2.3.2 Example Execution
3.2.3.3 Discussion
3.2.3.4 Permissions Required
3.2.3.5 Tips and Tricks

The MySQL privilege system permits you to create a set of permissions for each user. Sometimes the set of permissions are complex and may require multiple GRANT statements to effect. Other times, the user may acquire privileges over time.

Regardless of how it came about, you may find yourself needing to create a new user that has the same privileges as another user.