gistfile1.txt

# reset root password
    o Stop MySQL
        $ sudo /sbin/service mysqld stop
    o Restart it manually with the skip-grant-tables option: 
        $ mysqld_safe --skip-grant-tables
    o Run the MySQL client: 
        $ mysql -u root
    o Reset the root password manually with this MySQL command: 
        mysql> UPDATE mysql.user SET Password=PASSWORD('XXX') WHERE User='root';
    o Flush the privileges with this MySQL command: 
        mysql> FLUSH PRIVILEGES;