MySQL Forums
Forum List  »  Newbie

Case senstive database/schema name
Posted by: John Dunn
Date: August 23, 2017 05:16AM

I am running software that runs all sql in uppercase. The SQL select statement is failing because the database name is in lowercase (mydb).

e.g SELECT (*) FROM MYDB.MYTABLE;

SELECT command denied to user 'MYUSER'@'localhost' for table 'MYTABLE'

Works OK if query on mydb.MYTABLE

Is there a SIMPLE way to resolve this in MySQL?

Version is 5.5

Options: ReplyQuote


Subject
Written By
Posted
Case senstive database/schema name
August 23, 2017 05:16AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.