Re: 1130 Error remotely connecting - Daniel da Veiga - com.mysql.lists.win32

6 messages in com.mysql.lists.win32Re: 1130 Error remotely connecting

From	Sent On	Attachments
Jguel	24 Mar 2006 09:23
Daniel da Veiga	24 Mar 2006 10:03
Jguel	24 Mar 2006 10:11
Kristen G. Thorson	24 Mar 2006 10:19
Daniel da Veiga	24 Mar 2006 10:23
Jguel	24 Mar 2006 13:47

Subject:	Re: 1130 Error remotely connecting
From:	Daniel da Veiga (dani...@gmail.com)
Date:	03/24/2006 10:03:34 AM
List:	com.mysql.lists.win32

Check the manual for the syntax of the GRANT and REVOKE commands, also check for firewall settings, in order to be able to connect to MySQL remotely you need to open port 3306 in your (built-in or other) firewall.

On 3/24/06, Jguel <jgu...@prmc.com> wrote:

Ok - I am COMPLETELY new to MySql but am learning.

I want to be able to remotely connect the MySql DB running on Win2003 server.

When I try I get a 1130 error.

I can connect to the DB on the local machine and I was told to run these two commands:

grant usage on test.* to root@'hostname or ip' grant ALL on test.* to root@'hostname or ip'

but after I put that in I just have a ' ->' prompt - its not even a 'MySql>' prompt and I still can't remotely connect.

Can someone tell me EXPLICITY the EXACT commands I need to type in to do this and what do I type in after I just have the '->' prrompt to get back to the 'MySql>' prompt ??

Thank you!