Collections:
Rename an Existing User Account in MySQL
How To Rename an Existing User Account Name in MySQL?
✍: FYIcenter.com
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)
⇒ What Are User Privileges in MySQL
⇐ Listing All User Accounts in MySQL
2017-12-13, 1312🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on INSERT, UPDATE and DELETE Statements in MySQL...
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...
How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Somet...
What Is "mysqld" in MySQL? "mysqld" is MySQL server daemon program which runs quietly in background ...
How To Recover a Dropped Index in Oracle? If you have the recycle bin feature turned on, dropped ind...