Short References for Mysql Passwords related issues:
Mysqladmin command to change root password
If you have never set a root password for MySQL, the server does not require a password at all for connecting as root. To setup root password for first time, use mysqladmin command at shell prompt as follows:
mysqladmin -u root password NEWPASSWORD
However, if you want to change (or update) a root password, then you need to use following command
mysqladmin -u root -p'oldpassword' password newpass
For example, If old password is abc, and set new password to 123456, enter:
mysqladmin -u root -p'abc' password '123456'
HOWTO CHANGE MYSQL ‘FORGOTTEN’ ROOT PASSWORD
If you dont know the old mysql ROOT password and want to reset it, follow these steps !
First of all you will need to ensure that your database is stopped:
/etc/init.d/mysql stop ps -A | grep mysql
Now you should start up the database in the background, via mysqld_safe syntax
sudo mysqld_safe --skip-grant-tables &
Now that the server is running with the --skip-grant-tables flag you can connect to it without a password and complete the job:
Use the following commands to change the password of mysql root user
UPDATE mysql.user SET Password=PASSWORD(‘new_password’) WHERE User=’root’; FLUSH PRIVILEGES; exit sudo pkill mysql*
Now start the MYSQL
service mysql start
Now everything should be done and you should have regained access to your MySQL database(s); you should verify this by connecting with your new password:
mysql -u root -p
If you’d like to automate this process you could start by looking at this simple shell script which will allow you to reset a password with one command.