How to change USERNAME And PASSWORD of MySQL?

Question

I have installed the MySQL Server 5.0 on my Windows 7 OS.

My existing USERNAME And PASSWORD for the MySQL is "root" for both. Now I want to change both the USERNAME And the PASSWORD.

Can anyone tell me HOW and from WHERE can I change those?

Answer 1

You can simply execute the following query from the MySQL console:

 UPDATE mysql.user SET user='newusername',
 password=PASSWORD('newpassword') WHERE user='root';
 FLUSH PRIVILEGES;

Join the SQL Course by Intellipaat fast, to Learn SQL concepts in detail and get certified.

Watch the below MySQL video tutorial to gain more knowledge on MySQL...