Sinisa,
In the first case I was trying to connect to the Linux box using a MySQL
client on the Mac called MacSQL. This box is called malacoda.local.
I'm still getting the same error, trying to connect from a mysql client on
my NT system, called lucifer.local, to a server on Linux. I get Error 1130
Host "lucifier.local' is not allowed to connect to this MySQL server".
Is this message being sent back from the MySQL server per se or is it just a
standard error, which would be sent even if there was no connection at all?
I used the new syntax you sent me, and am logged in to NT as the user in the
GRANT statement.
Help!
Peter
> From: Sinisa Milivojevic <[EMAIL PROTECTED]>
> Date: Fri, 1 Jun 2001 21:31:48 +0300 (EEST)
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Re: MySQL remote connect
>
> Peter D Bethke writes:
>> Hello all,
>>
>> I'm running MySQL on SuSE Linux 7.0.
>>
>> I've been unable to connect to MySQL from a client on a remote system (both
>> systems behind the firewall) using a username/pw set up locally using the
>> GRANT ALL ON *.* TO user@% identified by "password" command.
>>
>> I know this is a big security hole to grant universal permissions in this
>> way, but I'm just trying to connect from anywhere else but locally, which i
>> can do.
>>
>> When trying to connect, I get the "host malacoda.local is not allowed to
>> connect to this MySQL server". Malacoda.local being the remote system that
>> is set up in the local hosts file on the Linux system.
>>
>> It's my understanding that setting up universal access using the grant
>> command will allow my to connect from anywhere regardless of host name or IP
>> addresss.
>>
>> Is there any other place, port setting, etc. I need to configure to get this
>> darned thing to work?
>>
>> Best,
>>
>> Peter Bethke
>>
>
>
> Hi!
>
>
> You should have used:
>
> grant all on *.* to user@"%" identified ....
>
> Simply put, you forgot to quote a wildcard.
>
>
> Regards,
>
> Sinisa
>
> For technical support contracts, goto http://order.mysql.com
>
> ____ __ _____ _____ ___ == MySQL AB
> /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
> /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
> /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
> /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____
> ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^
> /*/ \*\ Developers Team
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php