Das deutsche Python-Forum

Code: Alles auswählen

While I'm unsure about the original post, (some extra details like what distribution your on may help) in regards to the MacBook Pro, if your on tiger/leopard (10.4/10.5) the mysql.sock file would actually be under either /var/mysql.sock or /tmp/mysql.sock depending on wether you installed it via either source or package.

On leopard to get the mysql bindings to work you need to do the following (this worked for me):

Install Mysql (I used the x64 Intel Community Installer Package from MySQLs Dev Site)

Create a Symlink (they moved the default socket from /var to /tmp for some unknown reason)

sudo mkdir /var/mysql/
sudo ln -s /tmp/mysql.sock /var/mysql/mysql.sock

Install XCode Tools (if you haven't already as they're needed to compile the mysql bindings)

Code: Alles auswählen

import MySQLdb
import sys

try:
    conn = MySQLdb.connect (host = "127.0.0.1",
                        user = "webdev",
                        passwd = "xxxxxx",
                        db = "web")
    cursor = conn.cursor()
    cursor.execute ("""SELECT id, data FROM example""")
    row = cursor.fetchall()
    for r in row:
        print(r)
    cursor.close()
    conn.close()
except MySQLdb.Error, e:
    print "Error %d: %s" % (e.args[0], e.args[1])
    sys.exit(1)