Am Sat, 18. November 2006 19:07 schrieb John Meyer:
> Hi,
> When I try to set up MythTV, I get a blue screen and MythTV complains
> that it can't connect to MySQL, even though it is up and running and has
> the database and user set.
I would say that the password in /etc/mythtv/mysql.txt and the password of the
mythtv user in mysql are not the same.
By this mythtv looks for the password to conect to it's database in the config
file /etc/mythtv/mysql.txt and can't establish a connection to the database
because you set an other mysql password during the setup.
you have two choices.
- set the password in /etc/mythtv/mysql.txt according to the mythtv password
used in mysql
---8<--- /etc/mythtv/mysql.txt ----8<---
DBPassword=PasswordofMythtvinMysql
----8<--- ----8<--- ----8<--- ----8<---
Where
- or set the mythtv password of the mysql database to the one which is
defined in /etc/mythtv/mysql.txt
Open an xterm, become root and change the password (instead of
mythtvpasswd type your password) :
--- --- ---
su -
mysql -u root -p mysql
UPDATE user SET password=PASSWORD('mythtvpasswd') WHERE user="mythtv";
FLUSH PRIVILEGES;
quit
--- --- ---
I would prefer the first way, changing the password in /etc/mythtv/mysql.txt
regards,
thomas
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
