question

RohanJones-0800 avatar image
0 Votes"
RohanJones-0800 asked Mike-Ubezzi answered

Changing the parameters which are not supported on server parameter blade on Azure Database for MySQL

How can I change the parameter like "character_set_client" which are not supported on server parameter blade on Azure Database for MySQL?

azure-database-mysql
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Mike-Ubezzi avatar image
0 Votes"
Mike-Ubezzi answered

Though these parameters are not allowed in the server parameters blade, there is a workaround you can use to set below parameter through init_connect.

For example:

• Go to Azure Portal, then locate your Azure Database for MySQL

• Under the settings section, click Server Parameter to open the server parameter page

• Search for “init_connect”

• Put the parameters in the format: SET parameter_name=YOUR_DESIRED_VALUE in value column.

Example for setting multiple parameters: init_connect= SET character_set_client=utf8;SET character_set_database=utf8mb4;SET character_set_connection=latin1;SET character_set_results=latin1

• Click Save

NOTE: Please note that init_connect is executed for each client that connects to the server and it is at a connection level.

You can check the value of these parameter after above steps using below commend:

show variables like 'character_set%';

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.