Rename an Existing User Account in MySQL

Q

How To Rename an Existing User Account Name in MySQL?

✍: FYIcenter.com

A

If you want to change the name of an existing user account, you can use the "RENAME USER oldName TO newName" command. The tutorial exercise below shows you how to do this:

>cd \mysql\bin
>mysql -u root -pretneciyf mysql

mysql> RENAME USER dev TO dba;
Query OK, 0 rows affected (0.01 sec)

mysql> SELECT User, Password, Shutdown_priv FROM mysql.user;
+------+-------------------------------------------+-----+
| User | Password                                  | ... |
+------+-------------------------------------------+-----+
| root | *3735F1D8464342BA852E10101E55E422EBAAAF35 | Y   |
| dev  | *446BD97F308FBA0B9CBDC962C2842AD338BCE59E | N   |
+------+-------------------------------------------+-----+
2 rows in set (0.03 sec)

 

Managing User Accounts and Access Privileges in MySQL

⇒⇒MySQL Database Tutorials

2016-10-16, 171👍, 0💬