MySQLAdmin

To assign a password to the root user

  • log onto your system from a command-line interface (Terminal)
  • move to the mysql/bin or just mysql directory, depending upon your O/S

     ex.: 

         cd /usr/local/mysql/bin ( Unix )

              or

         cd c:\mysql\bin ( Windows )


  • enter the following, replacing thepassword with the password you want to use

     syntax: 

          mysqladmin -u root password 'thepassword'


     ex.: 

           mysqladmin -u root password destiny


keep in mind that passwords within MySQL are case-sensitive, so Kazan and kazan are not interchangeable.  The term password that precedes the actual quoted password tells MySQL to encrypt that string

To change the root user's password
Check the Current Status of MySQL