Moestl,
Tuesday, October 08, 2002, 10:42:09 AM, you wrote:
MW> When one is doing a GRANT statement at the database level the database name is
stored in mysql.db in lowercase letters only, regardless of the upper/lowercase
characters used for the database
MW> name at the GRANT statement.
MW> Example:
MW> GRANT SELECT ON SYSMON.* TO theUser@%
MW> results in having stored the database name "SYSMON" as "sysmon" at mysql.db,
column db.
MW> GRANT SELECT ON SysMon.* TO theUser@% will grant the privilege to the same
database "sysmon" as the statement above. On a Unix plattform there can be two
different databases "SYSMON" and "SysMon"!
MW> Furthermore, if one manually changes the database name back to the original name -
"SYSMON" - at the column mentioned above and re-run the statement there is a second
entry generated in mysql.db:
MW> the old one having "SYSMON" and the new one having "sysmon" as database name.
MW> As the database name is case-sensitive in Unix systems this is critical.
MW> I'm running on Win XP, and found this behavior in mysql-MAX NT versions 4.0.2 to
4.0.4.
MW> Is this a Bug or intended behaviour?
It's not a bug.
Seems, you start MySQL server with lower_case_table_names=1. In this
case all table/database names will be convert to lower case
(SYSMON->sysmon, SySMon->sysmon):
http://www.mysql.com/doc/en/Name_case_sensitivity.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
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
