1
Installation issues / Re: Access denied for user 'mythtv'@'localhost' (using password: YES)
« on: February 05, 2008, 07:29:12 am »
I had the same problem. It appeared as if the upgrade (I used the amd64 dvd to upgrade from i386 704) did not fully register the myth password. I fixed it by changing the password used by mythtv in the following places:
On the command line, log in to mysql and run the following commands (changing 'password' to something else.):
$ mysql -u root mythconverg
mysql> grant all on mythconverg.* to 'mythtv'@'%' identified by "password";
mysql> flush privileges;
mysql> grant all on mythconverg.* to 'mythtv'@'localhost' identified by "password";
mysql> flush privileges;
Then edit /etc/mythtv/mysql.txt and change the following line:
DBPassword=password
replacing the 'password' with your selected password.
And finally edit /etc/mythtv/mythweb.htaccess and change the following line:
setenv db_password "password"
again replacing the 'password' with your password.
Finally reboot the system. This jump started mythtv and allowed mythweb to work as well for me.
On the command line, log in to mysql and run the following commands (changing 'password' to something else.):
$ mysql -u root mythconverg
mysql> grant all on mythconverg.* to 'mythtv'@'%' identified by "password";
mysql> flush privileges;
mysql> grant all on mythconverg.* to 'mythtv'@'localhost' identified by "password";
mysql> flush privileges;
Then edit /etc/mythtv/mysql.txt and change the following line:
DBPassword=password
replacing the 'password' with your selected password.
And finally edit /etc/mythtv/mythweb.htaccess and change the following line:
setenv db_password "password"
again replacing the 'password' with your password.
Finally reboot the system. This jump started mythtv and allowed mythweb to work as well for me.