[mythtv-users] 0.25 to 0.26 upgrade issue with MYSQL

[Yeechang Lee]

Steve Greene <sgreene59 at verizon.net> says:
> Yep, set to my local IP subnet. It's behaving as if "skip-networking"
> were set.  I can set myth to "localhost" as the hostname and it
> connects.

I recently had to recreate my database from backup and found that,
contrary to the various instructions (such as
<URL:http://www.mythtv.org/wiki/MythTV-HOWTO_-_0.26>),

     grant all on mythconverg.* to mythtv@"%.mydomain.com" identified
     by "mythtv";

was insufficient to let mythbackend connect to the database on the
same machine. I had to specify the hostname with

     grant all on mythconverg.* to mythtv@"hostname.mydomain.com"
     identified by "mythtv";

I didn't edit the wiki because as a MySQL non-expert there is likely
something I'm missing that does permit the first line to work, but
there you go.

-- 
MythTV FAQ Q: "Cheap frontend/backend?" A: Revo, $200-300 @ Newegg
Q: "Record HD cable/satellite?" A: Hauppauge HD-PVR, $200 @ Newegg
Q: "Can't change Live TV channels w/multirec!" A: Hit NEXTCARD key
More answers @ <URL:http://www.gossamer-threads.com/lists/mythtv/>