Renaming a User in MySQL

There are instances in which a user is created according to current requirements. However, as the design progress and requirements freezes or changes, there is a possible need to change the user name itself.

Let us look at the example where a user named PERFORMANCE has to be renamed to PERFORMANCE_MGR

RENAME USER PERFORMANCE TO PERFORMANCE_MGR

The syntax above renames PERFORMANCE to PERFORMANCE_MGR. You can also explore what happens to the logged-in sessions of PERFORMANCE user.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Related Posts