MySQL Help - Remote Access

[Stephen]

Christopher Browne wrote:
> On 6/27/06, Stephen <stephen-d-bJEeYj9oJeDQT0dZR+AlfA at public.gmane.org> 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?
>
> Is it possible that there is some sort of firewall setting that is
> denying remote access?
>
> It would make a lot of sense for there to be a default setting
> somewhere [possibly in "network world"] that rejects remote
> connections; that represents a "secure by default" behaviour, which is
> pretty preferable, as compared to having things wide open, ready for
> Bad People to do Bad Things...

I don't have a firewall on the Linux box. It lies behind the router 
which I rely on to keep bad things out.

And the error message suggests that the connection is being denied, as 
opposed to being blocked.

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