Re: LUG: Question Ubuntu and mysql - Fri, 01 Sep 2006 18:20:14 -0400

Subject : Re: LUG: Question Ubuntu and mysql

From : Ken Whichard <wwhichard@nc.rr.[redacted]>

Date : Fri, 01 Sep 2006 18:20:14 -0400

OK,

I have done all of the suggested steps but still have the same problem - I
have nosed around several forums and from some of the comments found, I
have discovered the following in the my.cnf file:

bind-address 127.0.0.1

which, according to the comments above it replace the skip-networking
directive in the startup process. The comments leade me to believe that
this will prevent connections form other than the local host.

My question now is can I just delete the bind-address line or do I need to
replace it with something else?

BTW: my local network is behind a firewall so security from the outside
world is not a problem - I just want to be able to use the databases form
the windoze machine!

TIA

Ken

At 11:32 AM 9/1/2006, you wrote:

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