If you have used MySQL before you will know about the system server variables, you know such commands as SHOW VARIABLES; You can access most of them via the Azure portal or connect to MySQL and issues the commands you come to know about.

Let’s see a quick example. I connect to the server and run:

MySQL [(none)]> SHOW VARIABLES LIKE ‘tx%’;

Here I am looking for the isolation level, just for example. This isn’t SQL server, inner workings and behaviours are different. I want to show how you can change something and see its reflection in the Azure portal. Hence:

MySQL [(none)]> SET tx_isolation = ‘READ-COMMITTED’;

Query OK, 0 rows affected, 1 warning (0.037 sec)

MySQL [(none)]>  SHOW VARIABLES LIKE ‘tx%’;

Go to Azure Portal > MySQL server > settings > server parameters and the transaction isolation level

So here I changed it again to serializable.

I did a restart and connect via command line and can see the updated value: