Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ERROR lower_case_table_names

Status
Not open for further replies.

David Higgs

Programmer
May 6, 2012
390
GB
I have MySQL 8.0.21 Server Set Up and working on my Windows 10 PC.

I would like to be able to use Upper Case Database Names when using phpMyAdmin. The Program runs ok when lower_case_table_names=1 but gives the following error when lower_case_table_names=2

2020-07-15T06:50:41.118617Z 1 [ERROR] [MY-011087] [Server] Different lower_case_table_names settings for server ('2') and data dictionary ('1').

2020-07-15T06:50:41.126977Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.

2020-07-15T06:50:41.128262Z 0 [ERROR] [MY-010119] [Server] Aborting

I am able to change lower_case_table_names in My.ini but don't know how to change the "Data Dictionary"

Any help would be most appreciated.



Regards,

David.

Recreational user of VFP.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top