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: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org