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


Tip of the Day
Language: SQL
Expertise: Intermediate
Jun 19, 2019

WEBINAR:

On-Demand

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


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.

M S Sridhar
 
Thanks for your registration, follow us on our social networks to keep up-to-date