[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
>
>
>