[plug] mysql query

[William Kenworthy]

mysql has an odd password setup where you have to get it to connect to
user at host.  Set it to mythtvuser at 192.168.1.13.  Often the problem is
which host does it use.  If an internal box on a home lan, setting the
user as user@% does a wildcard and is often the only answer (e.g.n
tunnelled connections or where you want a large number of boxes to
connect), or add a user for all the permutations that you need.  default
is user#localhost See the docs, theyre quite good - search for "password
in the TOC of the html docs installed along with the package.

BillK


See the mysql 
On Mon, 2005-01-17 at 00:21 +0800, Jim Householder wrote:
> Hi
> 
> I'm trying to get mythtv 0.16 running on a single machine (192.168.1.13), but have the problem that it cannot connect to it's database.
> 
> The error is 
> #HY000Host '192.168.1.13' is not allowed to connect to this MySQL server
> 
> How do I 
> a) tell the server the ip address is ok, or
> b) tell mythtv to use localhost instead?
> 
> TIA
> Jim
> _______________________________________________
> PLUG discussion list: plug at plug.linux.org.au
> http://spark.plug.linux.org.au/cgi-bin/mailman/listinfo/plug
> Committee e-mail: committee at plug.linux.org.au
> 
-- 
William Kenworthy <billk at iinet.net.au>
Home!