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, 3290🔥, 0💬
Popular Posts:
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...
How To Look at the Current SQL*Plus System Settings in Oracle? If you want to see the current values...
How to continue to the next iteration of a WHILE loop in SQL Server Transact-SQL? How to use CONTINU...
How To Get the Definition of a View Out of the SQL Server in SQL Server? If you want get the definit...