1130 Error remotely connecting

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!

--
View this message in context: http://www.nabble.com/1130-Error-remotely-connecting-t133770 1.html#a3575600
Sent from the MySQL - Win32 forum at Nabble.com.


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: 1130 Error remotely connecting

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 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 'MySq=
l>'
> 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!
>
> --
> View this message in context: http://www.nabble.com/1130-Error-remotely-c=
onnecting-t1337701.html#a3575600
> Sent from the MySQL - Win32 forum at Nabble.com.
>
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: http://lists.mysql.com/win32?unsub=3Ddanieldaveiga@gma=
il.com
>
>


--
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

Re: 1130 Error remotely connecting

That doesnt help me.

Ive checked the MAN pages and its not clear enough to me.

Can't someone please just give me the exact commands I need to enter.. I
can't be the only one who has had this issue. And there is no firewall
between me and the remote machine - they are on the same network!
--
View this message in context: http://www.nabble.com/1130-Error-remotely-connecting-t133770 1.html#a3576494
Sent from the MySQL - Win32 forum at Nabble.com.


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

RE: 1130 Error remotely connecting

-----Original Message-----
From: Jguel [mailto:jguel@prmc.com]=20
Sent: Friday, March 24, 2006 1:12 PM
To: win32@lists.mysql.com
Subject: Re: 1130 Error remotely connecting


That doesnt help me.

Ive checked the MAN pages and its not clear enough to me.

Can't someone please just give me the exact commands I need to enter.. I
can't be the only one who has had this issue. And there is no firewall
between me and the remote machine - they are on the same network!

-------------------------




You are ending your GRANT statements with a semi-colon, right? You
should be getting back to the mysql> prompt from the -> prompt if you
enter a semi-colon.


kgt

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

Re: 1130 Error remotely connecting

On 3/24/06, Jguel wrote:
>
> That doesnt help me.
>
> Ive checked the MAN pages and its not clear enough to me.
>
> Can't someone please just give me the exact commands I need to enter.. I
> can't be the only one who has had this issue. And there is no firewall
> between me and the remote machine - they are on the same network!

Well, the fact that they're in the same network means nothing
regarding firewall, Windows has automatic protections that doesn't
allow remote connections. If you have OPEN this connections OR
DISABLED the firewall, then you have no firewall set, please inform us
about it.

We can't give you the "exact commands" you need to type, for three reasons:

1) We don't know your network, your IPs or hostnames.
2) We can give you commands that will open your server to a possible
attack by allowing every connection from everywhere, but that seems a
little wrong, anyway:

GRANT ALL PRIVILEGES on *.* to 'jhon'@'%';
careful with that, use at your own risk. This grant permissions to do
anything to any database to a user named "jhon" at any host.

Manual says you can give any permissions (check the manual for
permissions) on databases (check the manual for aliasing databases and
tables) in the format .