How do I change the name of the root user of the MySQL database

Publication Date:  2016-11-21 Views:  259 Downloads:  0
Issue Description
How do I change the name of the root user of the MySQL database
Solution
"Enter cmd to display the command line interface.

Access installation directory\eSight\MySQL\bin and run the following command:cd /d D:\eSight\MySQL\bin


Connect to the MySQL database as the root user and run the following command:mysql -uroot -pChangeme123

NOTE: The default password of the root user is Changeme123.




Change the user name.update mysql.user set user = 'root' where user = 'newUserName';
flush privileges;


NOTE: After the change, the user name is newUserName.


END