I've lost the root user password on my mythtv database server. I first noticed a problem when updating packages and getting a complaint from mythtv-database. I tried to run "dpkg-reconfigure --force mythtv-database" and got an error. I am running debian squeeze.
I've gone through the procedures to reset the root password using mysqld-safe, and it works for localhost. But, when I try "mysql -h192.168.0.4 -uroot -proot mysql" I get the following:
ERROR 1045 (28000): Access denied for user 'root'@'192.168.0.4' (using password: YES)
NOTE: My machine address is 192.168.0.4.