[KLUG Members] Connecting to MySQL

[Jon]

On Wednesday, March 24, 2004, at 02:27 PM, bill wrote:
> Jon wrote:
>> Ok.  I have set-up a test system on my iBook to learn a little more 
>> about how (L/M)AMP works.I am having problems connect to MySQL 
>> through phpMyAdmin.  I can connect as long as I'm not connected to a 
>> network - through loopback?,
>
> Define "I" as in "I can connect".  Are you on the same machine?  A 
> different machine?

" I " can connect and interact with MySQL through phpMyAdmin while on 
the same machine they are running on while the machine is not connected 
to the network.
" I " cannot connect with with MySQL (access denied "root or jon" 
@192.168.1.***) while on the same machine they are running on while the 
machine is connect to my home network. (through wireless access).
I have tried adding GRANT ALL PRIVILEGES on db.* 
"root@192.168.1.0/255.255.255.0" and GRANT ALL PRIVILEGES on db.* 
"jon@192.168.1.0/255.255.255.0"

> but when I have an IP to a Network I am refused
>> connection, because MySQL sees me as the IP address.  Username and 
>> password do not matter, connection is refused.
>
> What do you have the host set to?
>
host is set to "traveller.local" - as this is a test system.