David Higgs
Programmer
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.
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.