'MySql lower_case_table_names = 2 in Azure but MySql Workbench say it's = 1

I have created a MqSql v5.7 database on Azure and set the lower_case_table_names property to 2, to enable support for uppercase tablenames.

I have downloaded and installed the MySql Workbench v6.3.9 CE x64 edition and connected to my Azure MySql database.

I created a new schema name ecommerce and started creating a new table named Product. When I attempted to apply the change, I received the following error:-

Error Message

The server is configured with lower_case_table_names=1, which only allows lowercase characters in schema and table names. The object will be created as 'product'.

The value of the lower_case_table_names property reported in the Azure portal is different to the property value reported in MySql Workbench.

Azure MySql Configuration Azure Portal

MySql Workbench Configuration MySql Workbench

Am I missing something obvious here?

mysqlazureazure-sql-databasemysql-workbench


Solution 1:[1]

For Azure Database for MySQL, In MySQL 8.0, lower_case_table_name is set to 1 by default, and you can't change it.

Solution 2:[2]

The value MySQL Workbench shows comes directly from server variables. You can even run the query yourself:

enter image description here

If that still shows 1 then the value on the Azure website is plain wrong. I assume you double checked you are on the correct connection.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 bluetata
Solution 2 Mike Lischke

Related Questions