Re: 1130 Error remotely connecting

On 3/24/06, Jguel <[email protected]> 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 <db>.<table> using the "*" wildcard to a user
located at a host, using "%" as a wildcard and a hostname or IP with
masks (localhost, jhon, 10.0.0.1, etc). So:

GRANT <privilege> on <db>.<table> to '<user>'@'<host>';

3) If you are learning, learn it so you don't need to ask again. All
the information above was at the manual.

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