Hi,
Is there a defined behaviour for handling the case-sensitivety for user- and hostnames?
I did not find any information on this at the docs for the 4.0.3 MAX version which I'm
using.
For example, the following database connections are valid:
root@localhost
Root@localhost
However, the following connection is resulting in an "Connection failed: 1045 - Accss
denied for user: ..." error:
ROOT@localhost
ROot@localhost
It looks like the host parameter is completely insensitive for cases, every combination of
upper- and lowercase characters it taken.
To get it even more confusing, the values for user and host at the SHOW GRANTS FOR
[user]@[host] are BOTH FULLY case-sensitive.
Only the exact values as beeing stored at the mysql system tables are taken.
The following statements does return values:
SHOW GRANTS FOR root@localhost
The following statements will NOT return values:
SHOW GRANTS for Root@localhost
SHOW GRANTS for root@Localhost
Personnaly I think the same case-sensitivety behaviour should be implemented in every
aspect of the database functionallity.
If connecting as Root@LOCalhOST works a SHOW GRANTS FOR Root@LOCalhOST should work as
well.
Best regards,
Wolf
