What still does not work, but its not a problem since i "hardcoded"
the connection setup to the server. But sending the message

connect localhost root user pwd database(

gives me

could not log into MySQL Server.

defining the variables within the script does work.

(snip)

   try:
           db = MySQLdb.connect(host=str(host_), user=str(user_), passwd=str (pwd_), db=str(db_name_))
           cursor = db.cursor()
           print "PD mysql: logged into MySQL server !"
           return 1
   except:
           print "PD mysql: could not log into MySQL server !"
           return 0

there's lot's of different things that can go wrong when connecting to a db. the very generic try,except clause here is problematic because it doesn't really help you finding the exact error. use the code below to know what exactly went wrong and let us know the error message. add the "print traceback.format_exc()" also to your execute function. concerning getting the results, indexing lists on so on the best idea is to store the results inside python and access it via python functions so indexing is easy, clean and reliable and you don't have to bother trying that directly in pd (which is a major PITA if not impossible). and while this is likely to become a bit more complex it's also a good idea to wrap up the whole mess into a class anyway. i can give you an example later today or tommorrow if you don't know what i mean.

import traceback

def connect(host_="", user_="", db_name_="", pwd_=""): """ connect to MySQL server """ global db global cursor try: db = MySQLdb.connect(host=str(host_), user=str(user_), passwd=str (pwd_), db=str(db_name_)) cursor = db.cursor() print "PD mysql: logged into MySQL server !" return 1 except: print '-'*76 print "MySQL Error!" print '-'*76 print traceback.format_exc() print '-'*76 return 0