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
  • Email, SSL
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Add multiple IPs to a server

For example if you want to add a few IPs from the 111.123.123.1 class: [root@box ~]# cd...

Easy ruTorrent installer + Web server, FTP, Webmin (Ubuntu/Debian/Fedora/More)

All credit goes to Author brock from forums.rutorrent.org  original post here for reference also...

How to install VNC

How to install VNC : VNC is used to display an X windows session running on another computer....

How to install Lighttpd

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

How to install ImageMagick

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