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
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
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
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
