Re: LUG: Question Ubuntu and mysql - Fri, 01 Sep 2006 11:32:00 -0400

Subject : Re: LUG: Question Ubuntu and mysql

From : Jamil Hassan Spain <spain@ncssm.[redacted]>

Date : Fri, 01 Sep 2006 11:32:00 -0400

Ken..

The problem is that mysql needs to explicitly add a user for you to
connect from the windows box, normally denoted from the ip..
You need to log into ubuntu mysql as root and enter the following:

first) mysql -u root -p
a) use dbname;
b) grant all privileges on dbname.* to me@192.168.1.[redacted] identified by
'mypassword';
c) flush privileges; ( this will reload the mysql grant table so you can
have access instantly )
d) exit

now issue that connection from windoze or use mysql administrator
application to connect to that server on ubuntu.. If you want to
download the tools, use this link:
http://dev.mysql.com/get/Downloads/MySQLGUITools/mysql-gui-tools-5.0-r2-win32.msi/from/pick#mirrors

Jamil Spain
NCSSM

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

Replies :

Re: LUG: Question Ubuntu and mysql