Re: LUG: Question Ubuntu and mysql - Fri, 01 Sep 2006 08:41:20 -0400

Subject : Re: LUG: Question Ubuntu and mysql

From : John Klein <john_klein@ncsu.[redacted]>

Date : Fri, 01 Sep 2006 08:41:20 -0400

Ken Whichard wrote:
> Hope someone can help me with this one.
>
> I have a mysql server (ver 5.0) running on a linux box (Ubuntu) and can
> use it on the local machine without any problem.
>
> I want to be able to connect to it from a windoze machine that is on the
> local network with the linux box.
>
> When I ussue:
>
> mysql -u me -host 192.168.1.201 -p
>
> and enter the password when prompted, I get the following error.
>
>
> ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.1.201'
> (10061)
>
>
>
> Have I not set something on the Linux box or what?
>
> Any ideas will be appreciated.
>
> Ken

Ken,

I think you need to configure MySQL to accept remote connections with
something like:

grant all on yourdbname.* to me@"192.168.1.%" identified by "mypasswd";
flush privileges;
quit;

The % wildcard will allow access by account "me" with password
"mypasswd" access from any machine under 192.168.1

You might also need to open some firewall ports, if you've got your
firewall enabled.

Cheers!

John

--
John Klein
NC State University Information Technology Division
John_Klein@ncsu.[redacted] XXX-513-2817 / http://microsys.unity.ncsu.edu