0

I have an assignment for an SQL class in python and has bumped into a following error yesterday:

"InterfaceError: 2013: Lost connection to MySQL server during query".

I have searched the whole web, especially stack overflow, looking for an answer and unfortunately nothing helped. I altered the "wait_timeout" and other parameters yet the python keeps on prompting the error. Eventually, given that no answer written before helped, I resolve to asking the question on forum. Could you give me any suggestions? Unfortunately the exercise must be done in both Jupyter and MySQL, so no alternative can be chosen. Thanks! It is of utter importance for me.

Slava Rozhnev
  • 8,085
  • 6
  • 21
  • 35
ignacywawa
  • 21
  • 3
  • Typically this indicates either a network failure between the Jupyter server and the MySQL server, or that the MySQL connection timed out. Is this a very large table which takes multiple minutes to load? – Nick ODell Nov 19 '21 at 00:44
  • Yes, it is pretty big :). What should I do in such case? – ignacywawa Nov 20 '21 at 17:09
  • Does this answer your question? https://stackoverflow.com/questions/10563619/error-code-2013-lost-connection-to-mysql-server-during-query – Nick ODell Nov 20 '21 at 19:52
  • Not really. I am using XAMPP to create localhost on my MacBook (via phpMyAdmin) and could not find the setting mentioned in the post (unfortunately not using MySQL Workbench). Do you have any idea what it might be or where I can change the settings in regard to timeout? Thanks in advance :) – ignacywawa Nov 28 '21 at 10:11

0 Answers0