how to set mysql password
==========================


1. If you have never set a root password for MySQL

  $ mysqladmin -u root password NEWPASSWORD
  
  example:

  mysqladmin -u root password password


2. to change (or update) a root password


  $ mysqladmin -u root -p'oldpassword' password newpass
  

  example
  $ mysqladmin -u root -p'password' password 'password'

   
3. Change MySQL password for other user

   $ mysqladmin -u lei -p oldpassword password newpass





4*. Changing MySQL root user password using MySQL sql command

    1) Login to mysql server

       $ mysql -u root -p


    2) Use mysql database

        mysql> use mysql;


    3) Change password for user lei:

       mysql> update user set password=PASSWORD("NEWPASSWORD") where User='lei';

       example:

       mysql> update user set password=PASSWORD("password") where User='lei';
       

    4) Reload privileges

       mysql> flush privileges;
       mysql> quit