MySQL - Rename an Existing User Account in MySQL

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

2017-12-13, 472👍, 0💬

Scope Levels of User Privileges in MySQL
How Many Scope Levels Can User Privileges Apply in MySQL? MySQL supports 5 scope levels a user privilege can be granted: Global Level - A privilege granted at this level applies to all databases on the server. Privileges granted at the global level stored in "mysql.user" table. Database Level - A pr... 2017-12-09, 509👍, 0💬

Listing All User Accounts in MySQL
How To List All Existing User Accounts in MySQL? MySQL stores all existing user accounts in a table called "mysql.user". If you want see all user accounts, you can use the "SELECT" command as shown in the tutorial exercise below: >cd \mysql\bin >mysql -u root -pretneciyf mysql mysql&am... 2017-12-13, 475👍, 0💬

Rename an Existing User Account in MySQL
How To Rename an Existing User Account Name in MySQL? 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&gt... 2017-12-13, 473👍, 0💬

Deleting a User Account in MySQL
How To Delete a User Account in MySQL? If you want to delete a user account, you can connect to the server as "root" and use the "DROP USER ..." command to delete a user account. The tutorial exercise below shows you a good example: >cd \mysql\bin >mysql -u root -pretneciyf mysql mysql... 2017-12-13, 446👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.