[KLUG Members] Connecting to MySQL

bill members@kalamazoolinux.org
Wed, 24 Mar 2004 15:21:31 -0500


Are the MySQL database and PhpMyAdmin on the same machine?

What do you have set in config.inc.php?

Jon wrote:
> 
> 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.
> 
> _______________________________________________
> Members mailing list
> Members@kalamazoolinux.org
> 
> 
>