[mythtv-users] MySQL Connection Problems

Will Constable willconstable at gmail.com
Mon Aug 21 01:51:31 UTC 2006

Thanks a lot-- this mostly worked to fix my problem, although my mythweb is
broken.  Do you know if there are any special changes that need to be made
for mythweb?


-----Original Message-----
From: mythtv-users-bounces at mythtv.org
[mailto:mythtv-users-bounces at mythtv.org] On Behalf Of Kevin Kuphal
Sent: Sunday, August 20, 2006 5:17 PM
To: Discussion about mythtv
Subject: Re: [mythtv-users] MySQL Connection Problems

Will Constable wrote:
> I have a single machine setup and yet I have managed to cause 
> connection problems. Today I decided to change my hostname from 
> default (localhost.localdomain) to the hostname I'm used to my file 
> server being. This way I can map network shares from windows computers 
> using hostname instead of ip address, which keeps changing.
> Upon changing my hostname, mythtv broke. I thought it would be an easy 
> fix of changing ~/.mythtv/mysql.txt to reflect the new hostname. After 
> tinkering with both root's and the user 'myth' who autologons and 
> autoruns the frontend, it still does not work. I have tried playing 
> with granting privileges on mysql after reading other peoples 
> problems, but im not sure if this is actually the problem, but if it 
> is I don't know enough about mysql commands to figure it out.
> Mythtvsetup runs but does not seem to reflect my previous settings, 
> suggesting it does not connect to the DB. It does seem to have 
> connected though, so hopefully that doesn't mean it trashed the 
> contents of the DB.
> Essentially, I have a crippled system and after a few hours of 
> attempts I can't really be sure what values various settings had 
> earlier and how to get things working again. As a last resort I could 
> delete the database and reset the whole thing, but I really want to 
> preserve it. Any suggestions?

mythtv-users mailing list
mythtv-users at mythtv.org

More information about the mythtv-users mailing list