Pymysql Lost connection to MySQL server during query

Viewed 1146

I trying to run a simple query on a server using pymsql which shouldnt be an issue. Im virtually pulling my hair now. What am I missing.

 import pymysql

 connection = pymysql.connect(user='mak_aba', passwd='password',host='localhost',database='baba')

 cursor = connection.cursor(buffered=True)

 query = ("SELECT * FROM `orders`")

 cursor.execute(query)

 for item in cursor:
   print item  
1 Answers
Related