Last answered:

11 Sept 2022

Posted on:

30 Oct 2021

0

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

In practice exam 2 , Question 2
whenever i try to run the corresponding code
this error message shows up image.png

3 answers ( 0 marked as helpful)
Instructor
Posted on:

10 Dec 2021

1

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

Posted on:

04 Sept 2022

0

Hi Martin,

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

Thx

Anu

Instructor
Posted on:

11 Sept 2022

0

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

Submit an answer