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
