[mythtv-users] mysql permissions problem (long lines of mysql dataquoted)

[Tom Dexter]

>From: Mike Perkins
>
>Tom Dexter wrote:
> >
> >It might not be related to grant privs at
> > all.  If mysql is bound th 'localhost' in the my.cnf file, that can 
>allow
> > connections from localhost but nowhere else on the lan.  For example, I 
>had
> > to change the default of:
> >
> > bind-address                            = 127.0.0.1
> >
> > ...to...
> >
> > bind-address                             = 192.168.1.51
> >
> > ...on my backend in the my.cnf file or it flat out refused connections.
> >
>On my previous mythtv installation things ran without a problem until one 
>day
>I rebooted my front end and got stonewalled by mysql. Bit of poking around 
>and
>I discovered that the system had switched from using IP addresses to using
>hostnames for no obvious reason. If you don't have hostnames in your  mysql
>tables (as I didn't) you aren't going to get in. In the end I did belt and
>braces - added GRANT clauses for every IP address on my LAN (no wildcards, 
>it
>didn't take any notice of them) and clauses for every hostname, qualified 
>and
>unqualified. No problems since :).
>
>Mike Perkins
>

That's an odd one.  While mysql privileges by hostname require DNS lookups, 
I've never seen a situation where using ip addresses and wildcards didn't 
work.  In any case, the issue I was referring to with the bind address is 
another issue entirely.  The situation I was describing is where mysqld is 
bound to the local loopback, and the remote machine will never even get the 
network connection to mysqld it needs to attempt the mysql login in the 
first place.  This acts much like it would with skip-networking enabled.

Tom

_________________________________________________________________
Booking a flight? Know when to buy with airfare predictions on MSN Travel. 
http://travel.msn.com/Articles/aboutfarecast.aspx&ocid=T001MSN25A07001