Solved: MySQL Help - Remote Access

Stephen stephen-d-bJEeYj9oJeDQT0dZR+AlfA at public.gmane.org
Wed Jun 28 02:38:21 UTC 2006


The user table, hosts field wants a % and not a *

I paid my dues on this lesson.

lol

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


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