To reset the password for MySQL

– First you will need to telnet into your server using a telnet client.
* For example, use the ‘Putty’ telnet to telnet into your server.
– Once logged in, type mysql -u root -p
* You will be prompted for the ‘root’ password.
– Type in use mysql;
– Type in update user set password=PASSWORD(“YOURNEWPASSWORD”) where user=’theusername';