At 20:25 -0500 9/23/02, Paul DuBois wrote: >At 16:43 -0700 9/23/02, Jan Steinman wrote: >> >From: "Moestl, Wolfgang" <[EMAIL PROTECTED]> >>> >>>Is there a defined behaviour for handling the case-sensitivety for >>>user- and hostnames? >> >>According to the specification for the Domain Name System (DNS), >>Internet hostnames are always supposed to be case-insensitive. >> >>Since other entities in MySQL are case-sensitive, this may seem >>inconsistent, but it is imposed by international standards. It is >>NOT under the control of MySQL. >> >>>To get it even more confusing, the values for user and host at the >>>SHOW GRANTS FOR [user]@[host] are BOTH FULLY case-sensitive. >> >>If verified, this is a bug. DNS-based hostnames should NEVER be >>case-sensitive. > >MySQL behaves like this: > >Usernames, passwords, and database and table names are case sensitive in >grant table entries. > >Hostnames and column names are not. > >> >>The fact that you observed this using the "magic" hostname >>"localhost" may indicate that MySQL is "cheating" by doing its own >>management of this unique name. Any other fully qualified domain >>name should go through your operating system's address resolver, >>and had better be case-insensitive! > >"localhost" is indeed interpreted specially in MySQL. On UNIX, it means >"connect using the UNIX domain socket rather than TCP/IP". So in this >case, DNS is not involved. > >In any case, I do not observe a difference between setting up >user accounts using host 'localhost' versus 'LOCALHOST'. > >I *do* observe case sensitive hostname behavior for SHOW GRANTS. >This should not be. I'll ask about it.
Okay, there was indeed a case comparison problem with SHOW GRANTS. This has now been fixed for the upcoming 4.0.4 release. > >> >>On UNIX and clones: "nslookup localhost" "nslookup Localhost" and >>"nslookup LoCaLhOsT" all answer the same IP. >> >>If case-insensitivity with "localhost" is important, you might just >>map some other name to your machine and use that instead. This is >>also a good policy in case you later want to move your database to >>its own machine. For example, I have "data" defined as a CNAME in >>DNS for the machine I'd normally refer to as "localhost." It seems >>to work -- as it should -- if I call it "data", "Data", "dATA", etc. >> >>-- >>: Jan Steinman -- nature photography: <http://www.Bytesmiths.com> >>: Bytesmiths -- artists' services: <http://www.Bytesmiths.com/Services> >>: Join the forums at <http://www.Bytesmiths.com/wiki> --------------------------------------------------------------------- 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