'Lost connection to MySQL server during query'

[aas...@iimjobs.com]

Hi all,

Can anyone help me in sorting out this error. I am getting this error when I am trying to run a query .

'Lost connection to MySQL server during query'

Here is my code :

conn = pymysql.connect(host='123', port=123, user='123', passwd='123', db='matrix')

   

cur = conn.cursor()

cur.execute("SELECT ID,name FROM matrix")

print(cur.description)

print()

for row in cur:

   print(row)

cur.close()

conn.close()

Whole error-----

cur = conn.cursor()
      4 
      5 cur.execute("SELECT ID,name FROM matrix")

C:\Users\ssl\Anaconda3\lib\site-packages\pymysql\__init__.py in Connect(*args, **kwargs)
     86     """
     87     from .connections import Connection
---> 88     return Connection(*args, **kwargs)
     89 
     90 from pymysql import connections as _orig_conn

C:\Users\ssl\Anaconda3\lib\site-packages\pymysql\connections.py in __init__(self, host, user, password, database, port, unix_socket, charset, sql_mode, read_default_file, conv, use_unicode, client_flag, cursorclass, init_command, connect_timeout, ssl, read_default_group, compress, named_pipe, no_delay, autocommit, db, passwd, local_infile, max_allowed_packet, defer_connect)
    655             self.socket = None
    656         else:
--> 657             self.connect()
    658 
    659     def close(self):

C:\Users\ssl\Anaconda3\lib\site-packages\pymysql\connections.py in connect(self, sock)
    848             self.socket = sock
    849             self._rfile = _makefile(sock, 'rb')
--> 850             self._get_server_information()
    851             self._request_authentication()
    852 

C:\Users\ssl\Anaconda3\lib\site-packages\pymysql\connections.py in _get_server_information(self)
   1059     def _get_server_information(self):
   1060         i = 0
-> 1061         packet = self._read_packet()
   1062         data = packet.get_all_data()
   1063 

C:\Users\ssl\Anaconda3\lib\site-packages\pymysql\connections.py in _read_packet(self, packet_type)
    898             bytes_to_read = btrl + (btrh << 16)
    899             #TODO: check sequence id
--> 900             recv_data = self._read_bytes(bytes_to_read)
    901             if DEBUG: dump_packet(recv_data)
    902             buff += recv_data

C:\Users\ssl\Anaconda3\lib\site-packages\pymysql\connections.py in _read_bytes(self, num_bytes)
    920         if len(data) < num_bytes:
    921             raise err.OperationalError(
--> 922                 2013, "Lost connection to MySQL server during query")
    923         return data
    924 

OperationalError: (2013, 'Lost connection to MySQL server during query')

[Naoki INADA]

Connection is closed from MySQL server side.

Your program can't get any information about the reason.

You should check MySQL server's error log.