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

Rohan Jones 286 Reputation points
2020-05-18T04:41:50.923+00:00

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 for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
440 questions
No comments
{count} votes

Accepted answer
  1. Mike Ubezzi 2,771 Reputation points
    2020-05-18T17:00:56.947+00:00

    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%';

    No comments

0 additional answers

Sort by: Most helpful