MySQL Tips

Try stopping the mysql daemon

CODE

/etc/init.d/mysql stop

Run

CODE

mysqld_safe --skip-grant-tables &

Enter as root

CODE

mysql -u root -p

To change root password

CODE

mysql client - mysql -u root

and write

CODE

use mysql
update user set password=PASSWORD(”NEW-ROOT-PASSWORD”) where User=’root’;

Source