MySQL Help - Remote Access

Stephen stephen-d-bJEeYj9oJeDQT0dZR+AlfA at public.gmane.org
Wed Jun 28 01:47:50 UTC 2006


David Thornton wrote:
> Stephen wrote:
>> A bit off topic but I am using a (Red Hat) Linux server.
>>
>> I have Apache, PHP, Samba, and local connections to MySQL running 
>> just fine.
>>
>> I want to do remote connections using MySQL administrator.
>>
>> I have added rows (Using GRANT) in the user table with host set to * 
>> for the accounts I want to use. (This is on a private network, and 
>> for testing).
>>
>> I flushed the privileges, and even rebooted the machine.
>>
>> But I get an error saying I cannot connect from the remote computer.
>>
>> Is there some global setting in a config file, or something else I 
>> must do?
>>
>> Thanks
>> Stephen
>>
>> -- 
>> The Toronto Linux Users Group.      Meetings: http://tlug.ss.org
>> TLUG requests: Linux topics, No HTML, wrap text below 80 columns
>> How to UNSUBSCRIBE: http://tlug.ss.org/subscribe.shtml
> Just to be sure...
>
> You added the "grant" lines to the remote MySQL server right? not your 
> local mysql instance?
>
> Can you telnet to port 3306 from the client to the server?
>
> Can you use the account you created on the server ( while local to the 
> server )?
>
> Are you refering to the remot mahcine by IP or by name? Star with IP 
> address and then move to name resolution.
>
I only have MySQL on the server. The local machine having the problem 
with connecting only has MySQL Administrator and MySQL Query Browser. 
Just client software.

I was using terminal on the server to execute the GRANT statements. I 
verified with select statements that the updates worked.

When I try to telnet from the client to the server on port 3306 I get 
the error "Host 192.168.2.100 is not allowed to connect to this MySQL 
server" which is the exact error I get when trying to connect using 
MySQL Administrator.

Any local server access I try works exactly as expected.

I try to connect to the server with MySQL by IP address.


This is getting frustrating. I have been through tons of docs and done 
dozens of googles.

The MySQL docs say networking is on by default.

I explicitly added a bind-address and port statement to my.cnf to no effect.


I tried to figure out the Red Hat boot initialization but is very far 
away from standard linux. So many rc.* files....

Can't give up though.
Stephen

--
The Toronto Linux Users Group.      Meetings: http://tlug.ss.org
TLUG requests: Linux topics, No HTML, wrap text below 80 columns
How to UNSUBSCRIBE: http://tlug.ss.org/subscribe.shtml





More information about the Legacy mailing list