localhost does not mean 127.0.0.1 Localhost is the socket to connect to and has is separate from IP addresses. The % is for IP address access. That is why there are 2 ways. I would hardly call that redundant.
Roger
That's true on Unix, but if Jim (the original poster) has entries for [EMAIL PROTECTED] and [EMAIL PROTECTED], then he's probably running on Windows, and Unix sockets are irrelevant. localhost can be used for named pipe connections, though: the [EMAIL PROTECTED] entry will work for that, whereas [EMAIL PROTECTED] will not.
Note too that because [EMAIL PROTECTED] allows access to any remote host anywhere, it's particularly important to make sure either that that account has a password or that you remove it. Otherwise your server is wide open.
> http://www.alpsgiken.co.jp-----Original Message----- From: Joel Rees [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 08, 2003 8:30 PM To: [EMAIL PROTECTED] Subject: Re: [EMAIL PROTECTED]
> Not sure where these came from, but in my users I've got a [EMAIL PROTECTED] and a > [EMAIL PROTECTED] Is this redundant, or is there a reason for this?
Well, some people might say it's redundant, but it _is_ by design --
http://www.mysql.com/doc/en/Privileges.html
> ...
-- Joel Rees, programmer, Kansai Systems Group Altech Corporation (Alpsgiken), Osaka, Japan
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
