dcsimg
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
 

Tip: Renaming a User in MySQL

Learn how to change a user name in MySQL, as requirements may be updated along the development process.


advertisement

WEBINAR:

On-Demand

Building the Right Environment to Support AI, Machine Learning and Deep Learning


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.

 

Visit the DevX Tip Bank

 





   
Sridhar M S. is a Java developer from Bangalore, India. He holds a master's degree in Computer Science.
Thanks for your registration, follow us on our social networks to keep up-to-date