[mythtv-users] Cannot connect to MySql server from clients

Thomas Repetti trepetti at verizon.net
Wed Aug 2 22:12:04 UTC 2006


I recently changed my broadband provider and had to change my in-house IP
subnet.  Since then, I have been unable to use Tapeworm to connect to the
SQL server and display the list of movies on disk.  I did a sniffer trace,
and the error is:

Host 'dad-1.107es.com' is not allowed to connect to this MySQL server

I did not think that the accounts on the SQL server were tied to the subnet,
but I must think that this is a possibility.  So.....2 questions.

1 - Is there an easy fix for this?  Is so, can someone step me through it,
2 - I have considered a rebuild of the system.  All my video is on a
separate volume, and I was thinking I could back up my existing database,
rebuild the MythTV server, reload the database from backup, and re-mount the
video directory.  Part of me thinks I might reintroduce the problem if it is
caused by a db record, but I'd be willing to try.  At worst it would bring
me right back to the original problem, and at best it would give me
experience in a bare-metal restore of the MythTV server.

Thanks



More information about the mythtv-users mailing list