Collections:
Other Resources:
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)
2017-12-13, 313👍, 0💬
Popular Posts:
Why I Can Not Enter 0.001 Second in DATETIME values in SQL Server Transact-SQL? If you enter millise...
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...
How To Define an External Table in a Text File in Oracle? You can use the CREATE TABLE statement to ...
How To Execute a Stored Procedure in SQL Server Transact-SQL? If you want execute a stored procedure...
How To Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? I...