List:General Discussion« Previous MessageNext Message »
From:Victoria Reznichenko Date:September 23 2002 12:38pm
Subject:re: Case sensitivety behaviour
View as plain text  
Monday, September 23, 2002, 9:49:14 AM, you wrote:

MW> Is there a defined behaviour for handling the case-sensitivety for user- and
> hostnames?
MW> I did not find any information on this at the docs for the 4.0.3 MAX version which
> I'm using.

MW> For example, the following database connections are valid:
MW> root@localhost
MW> Root@localhost

MW> However, the following connection is resulting in an "Connection failed: 1045 -
> Accss denied for user: ..." error:
MW> ROOT@localhost
MW> ROot@localhost

MW> It looks like the host parameter is completely insensitive for cases, every
> combination of upper- and lowercase characters it taken.

MW> To get it even more confusing, the values for user and host at the SHOW GRANTS FOR
> [user]@[host] are BOTH FULLY case-sensitive.
MW> Only the exact values as beeing stored at the mysql system tables are taken.

MW> The following statements does return values:
MW> SHOW GRANTS FOR root@localhost

MW> The following statements will NOT return values:
MW> SHOW GRANTS for Root@localhost
MW> SHOW GRANTS for root@Localhost

MW> Personnaly I think the same case-sensitivety behaviour should be implemented in
> every aspect of the database functionallity.
MW> If connecting as Root@LOCalhOST works a SHOW GRANTS FOR Root@LOCalhOST should work
> as well.

What OS do you use? I tested your examples on 4.0.3-max on Win and
RedHat and all worked well. I got "Access denied" error in any case
except root@localhost when I try to connect and SHOW GRANTS also
worked as well:

mysql> show grants for 'Root'@'localhost';
ERROR 1141: There is no such grant defined for user 'Root' on host 'localhost'
mysql> show grants for 'root'@'Localhost';
ERROR 1141: There is no such grant defined for user 'root' on host 'Localhost'

For technical support contracts, goto
This email is sponsored by
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   Victoria.Reznichenko@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB /

Case sensitivety behaviourWolfgang Moestl23 Sep
  • re: Case sensitivety behaviourVictoria Reznichenko23 Sep
Re: Case sensitivety behaviourJan Steinman24 Sep
  • Re: Case sensitivety behaviourPaul DuBois24 Sep
    • Re: Case sensitivety behaviour [followup re: bugfix]Paul DuBois26 Sep