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 <[email protected]> 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!
>
> --
> View this message in context: http://www.nabble.com/1130-Error-remotely-connecting-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/[email protected]
>
>


--
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/[email protected]