How to change mysql root password Print

MySQL Change root Password:

Setting up mysql password is one of the essential tasks. By default root user is MySQL admin account. Here, We are going to discuss about                                                        ”  How to change mysql root password ? ”

Instructions:

1) unsing mysql admin

• mysqladmin -u root -p ‘oldpassword’ password ‘newpass’
• E.g :- mysqladmin -u root -p luck password ecvps

2) Changing mysql password for another user

• If you want to change the password for particular user, you need to specify that user name.
• E.g :- mysqladmin -u sam -p luck password ecvps  - here sam is the user

3) Using mysql command

• mysql -u root -p – login to mysql server
• mysql> use mysql;    -  use the mysql database
• mysql > update user set password=PASSWORD(“new password”) where User = ‘ sam ‘ ;
• mysql> flush privileges;
• mysql>bye