How to change connect_timeout in Azure MySQL

Question

I have Azure MySQL instance (managed instance) and I want to change connect_timeout in server options. When I in MySQL Workbench do

SHOW VARIABLES LIKE 'connect_timeout';

The result is 'connect_timeout', '10' the same result I get if I connect to mysql instance via command line.

How I can change this option? In Azure portal there is "Server parameters" and there is only wait_timeout 120 interactive_timeout 28800

But there is no connect_timeout.

Also I've tried to do

SET GLOBAL connect_timeout=30;

But got an error ERROR 1227 (42000): Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation

Thank you

Answer 1

You need to change wait_timeout value on Azure > Your server > Server parameters.