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