Veronica,
That's maybe true, I'll check it. As it's the default setting on Windows and I've
never changed it I guess it's on.
If the flag lower_case_table_names is turned on, I would expect that SHOW DATABASES
os SHOW TABLES is returning lowercase-only names as well?
I do get back the exact database and table names as the files in the DATA directory
are named, including full upper/lowercases, thus I do get back the name as originally
specified when creating the database / table.
The manual says (including LOOKUP queries):
8<=======================================
If lower_case_table_names is 1 MySQL will convert all table names to lowercase on
storage and lookup. (From version 4.0.2, this option also applies to database names.)
=======================================>8
Thanks!
Best regards,
Wolf
-----Originalnachricht-----
Von: Victoria Reznichenko
An: [EMAIL PROTECTED]
Gesendet: 08.10.2002 12:44
Betreff: re: Bug at GRANT statement?
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
---------------------------------------------------------------------
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
