mysql question: it alwasy timeout

[FINDME]

hello, when I run a SQL to update MySQL database, it will take about 1 mins to finish.
and this SQL can work prefect in NAVICAT, but fail in ProjectMaker. It seems that the max time for run a SQL in ProjectMaker is 30s, or it will fail. how can I fix this bug?

 

[EtaLasquera]

Thats not a bug, you can set the timeout into your connection string.
Just set timeout to higher value.
I don't use mysql... in sql server the timeout setting is Connect Timeout=600

 

[FINDME]

Thats not a bug, you can set the timeout into your connection string.
Just set timeout to higher value.
I don't use mysql... in sql server the timeout setting is Connect Timeout=600

I will try it

 

[VladZen]

Yes, timeout can be set in connection string

 

[FINDME]

Yes, timeout can be set in connection string

it seems do not work to set a Timeout.
although I set connectiontimeout=3600 but it still fail in 30s

 

[FINDME]

find way to this issue
add defaultcommandtimeout=time to connection string