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