Here is a good link to change mysql root password if you have root access to the machine:
The fastest way to change it (debian based):
create sql that changes the password – sometginh like this:
file= “/tmp/file-$$.sql”
echo “SET PASSWORD FOR root@localhost = PASSWORD(‘NEW ROOT PASS’);” > $file
/etc/init.d/mysql stop
mysqld_safe –init-file=$file &
killall -9 mysqld_safe
/etc/init.d/mysql start
Some additional links:
recoever mysql root pass
recoever mysql root pass (long explanation)
recoever 3 choice – more variants
