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, 1319🔥, 0💬
Popular Posts:
Where to find SQL Server Transact-SQL language references? You can find SQL Server Transact-SQL lang...
How To Change the Name of a Database User in SQL Server? If you want to change the name of an existi...
What Are Out-of-Range Errors with DATETIME values in SQL Server Transact-SQL? When you enter DATETIM...
How REAL and FLOAT Literal Values Are Rounded in SQL Server Transact-SQL? By definition, FLOAT(n) sh...
How To Get the Definition of a Stored Procedure Back in SQL Server Transact-SQL? If you want get the...