Fwd: Table names case sensitivity
Hi all, My problem goes away after I have upgraded MySQL from 3.23.41 to 3.23.46. Thanks you for anyone who have made suggestions or who have tried to figure out the solution. Kent. --- Mr Kent Cheung [EMAIL PROTECTED] wrote: Date: Wed, 30 Jan 2002 20:01:21 -0800 (PST) From: Mr Kent Cheung [EMAIL PROTECTED] Subject: Table names case sensitivity To: MySQL Discussion [EMAIL PROTECTED] Dear MySQL community, I am new MySQL user. I want to migrate a M$ SQL Server database to MySQL in a Linux box. Since table names in MySQL@Linux is case sensitive, I am having troubles connecting to the server via ODBC from a Windows box. I search the documentation and find that I may be able to disable the case sensitivity by setting the variable called lower_case_table_names to 1 when starting the server. I edit my.cnf and restart the server. Everything seems OK. mysqladmin and the Show Variables command in mysql confirm that this variable is now 1 instead of 0 before I make the changes. I have also changed the schema so that all table names are now in lower cases. However, when I perform a select, eg., SELECT * FROM Company; Then, an error occurs that tells me that the user xxx is not allowed select the table. Of course, there is no error when the following SQL is submitted: SELECT * FROM company; I change my.cnf back and repeat the above tests and the error persists. Thus, nothing seems to be changed by setting the variable. Have I missed anything? Thanks in advance. __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.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 __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.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
RE: Table names case sensitivity
Neil, Thank you for your suggestion. Unfortunately, the Grant command grants privileges to lower case table names also. I have also tried to find solution from archive of mysql mail lists but nothing useful have been found. Kent. --- Neil Silvester [EMAIL PROTECTED] wrote: -Original Message- From: Mr Kent Cheung [mailto:[EMAIL PROTECTED]] SELECT * FROM Company; Then, an error occurs that tells me that the user xxx is not allowed select the table. Of course, there is no error when the following SQL is submitted: SELECT * FROM company; I change my.cnf back and repeat the above tests and the error persists. Thus, nothing seems to be changed by setting the variable. I am not quite sure but, if you had set table privileges for your tables using grant statements, these could be incorrectly pointing to the wrong databases still. So if you granted GRANT ALL ON xxx.Company TO user@host IDENTIFIED BY password you would get errors because you only have permission to Company and not company. Just a thought. Neil Silvester Heat and Control Pty Ltd __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.com __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.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
Table names case sensitivity
Mr, Thursday, January 31, 2002, 6:01:21 AM, you wrote: MKC Dear MySQL community, MKC I am new MySQL user. I want to migrate a M$ SQL Server MKC database to MySQL in a Linux box. Since table names in MKC MySQL@Linux is case sensitive, I am having troubles MKC connecting to the server via ODBC from a Windows box. MKC I search the documentation and find that I may be able MKC to disable the case sensitivity by setting the MKC variable called lower_case_table_names to 1 when MKC starting the server. I edit my.cnf and restart the MKC server. Everything seems OK. mysqladmin and the Show MKC Variables command in mysql confirm that this variable MKC is now 1 instead of 0 before I make the changes. I MKC have also changed the schema so that all table names MKC are now in lower cases. MKC However, when I perform a select, eg., MKC SELECT * FROM Company; MKC Then, an error occurs that tells me that the user xxx MKC is not allowed select the table. Of course, there is MKC no error when the following SQL is submitted: MKC SELECT * FROM company; MKC I change my.cnf back and repeat the above tests and MKC the error persists. Thus, nothing seems to be changed MKC by setting the variable. MKC Have I missed anything? Yes, look in the manual: http://www.mysql.com/doc/N/a/Name_case_sensitivity.html If you set option lower_case_table_names=1, you should convert your old table names befor starting mysqld. -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [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
Fwd: Table names case sensitivity
Hi, As what I described in the original text, I have changed the table names to lower cases. Thus, I think I have done exactly what the manual says. Is this a bug or what have I missed? Thanks for your suggestion anyway. Kent. --- Egor Egorov [EMAIL PROTECTED] wrote: Date: Thu, 31 Jan 2002 12:12:01 +0200 To: [EMAIL PROTECTED] From: Egor Egorov [EMAIL PROTECTED] Subject: Table names case sensitivity Mr, Thursday, January 31, 2002, 6:01:21 AM, you wrote: MKC Dear MySQL community, MKC I am new MySQL user. I want to migrate a M$ SQL Server MKC database to MySQL in a Linux box. Since table names in MKC MySQL@Linux is case sensitive, I am having troubles MKC connecting to the server via ODBC from a Windows box. MKC I search the documentation and find that I may be able MKC to disable the case sensitivity by setting the MKC variable called lower_case_table_names to 1 when MKC starting the server. I edit my.cnf and restart the MKC server. Everything seems OK. mysqladmin and the Show MKC Variables command in mysql confirm that this variable MKC is now 1 instead of 0 before I make the changes. I MKC have also changed the schema so that all table names MKC are now in lower cases. MKC However, when I perform a select, eg., MKC SELECT * FROM Company; MKC Then, an error occurs that tells me that the user xxx MKC is not allowed select the table. Of course, there is MKC no error when the following SQL is submitted: MKC SELECT * FROM company; MKC I change my.cnf back and repeat the above tests and MKC the error persists. Thus, nothing seems to be changed MKC by setting the variable. MKC Have I missed anything? Yes, look in the manual: http://www.mysql.com/doc/N/a/Name_case_sensitivity.html If you set option lower_case_table_names=1, you should convert your old table names befor starting mysqld. -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [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 __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.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
Fwd: Table names case sensitivity
Mr, Thursday, January 31, 2002, 12:29:24 PM, you wrote: MKC Hi, MKC As what I described in the original text, I have MKC changed the table names to lower cases. Thus, I think MKC I have done exactly what the manual says. Is this a MKC bug or what have I missed? You have grants on database.Company instead of database.company You should update permissions for you. MKC Thanks for your suggestion anyway. MKC Kent. [skip] MKC I search the documentation and find that I may be able MKC to disable the case sensitivity by setting the MKC variable called lower_case_table_names to 1 when MKC starting the server. I edit my.cnf and restart the MKC server. Everything seems OK. mysqladmin and the Show MKC Variables command in mysql confirm that this variable MKC is now 1 instead of 0 before I make the changes. I MKC have also changed the schema so that all table names MKC are now in lower cases. MKC However, when I perform a select, eg., MKC SELECT * FROM Company; MKC Then, an error occurs that tells me that the user xxx MKC is not allowed select the table. Of course, there is MKC no error when the following SQL is submitted: MKC SELECT * FROM company; -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [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
Table names case sensitivity
Dear MySQL community, I am new MySQL user. I want to migrate a M$ SQL Server database to MySQL in a Linux box. Since table names in MySQL@Linux is case sensitive, I am having troubles connecting to the server via ODBC from a Windows box. I search the documentation and find that I may be able to disable the case sensitivity by setting the variable called lower_case_table_names to 1 when starting the server. I edit my.cnf and restart the server. Everything seems OK. mysqladmin and the Show Variables command in mysql confirm that this variable is now 1 instead of 0 before I make the changes. I have also changed the schema so that all table names are now in lower cases. However, when I perform a select, eg., SELECT * FROM Company; Then, an error occurs that tells me that the user xxx is not allowed select the table. Of course, there is no error when the following SQL is submitted: SELECT * FROM company; I change my.cnf back and repeat the above tests and the error persists. Thus, nothing seems to be changed by setting the variable. Have I missed anything? Thanks in advance. __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.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