whenever I run Q2 code that issue shows up: 'Lost connection to MySQL server during query'

Hi Mahran!

Thanks for reaching out.

You can try changing the DBMS connection read timeout interval (in seconds) setting in the SQL Editor tab in the workbench's preferences. Change it to 180, for example. Then restart the Workbench or reconnect to the DBMS and rerun the query.

Hope this helps.
Best,
Martin

Hi Martin,

I am getting same error - in spite of changing the setting as you instructed. kindly help !

Thx

Anu

Hi Anuradha!

Thanks for reaching out.

Sorry to hear the previous instructions didn't help. Please allow me to remind you that reconnecting to the DBMS is key to applying them into practice.

Can you please support your question with a screenshot containing the settings you've altered, so that we can assist you better? Thank you.

Looking forward to your answer.
Best,
Martin