How to change mysql root password

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

Was this answer helpful?

 Print this Article

Also Read

Install Rar/Unrar centos 6

for 64 bit install unrar centos x64#wget...

How to install Lighttpd

nstalling Lighttpd : Lighttpd is available via the RPMForge repositories RPMForege i386 install...

Changing permissions only on files or only on directories

The following two commands will change the permissions only on the files in a directory even...

How to install mod_evasive

  How to install mod_evasive How to install mod_evasive on a Directadmin server by admin on...

How to install ImageMagick

Install ImageMagick: ImageMagick is a software suite to create, edit, and compose bitmap...