«
»

MySQL, Python and MacOS X 10.6 (Snow Leopard)

This has been already mentioned in on a few blogs, but I thought it would be good to post here too. Note: this is not using MacPorts!

To get MySQL and Python going on MacOS X 10.6 you need the following:

Install MySQL using the tar ball and make sure you get it up and running.

Compile MySQL-python (leave out setting the $PATH when it's already done):

shell> PATH="/usr/local/mysql/bin:$PATH"
shell> tar xzf MySQL-python-1.2.3c1.tar.gz
shell> cd MySQL-python-1.2.3c1
shell> ARCHFLAGS="-arch x86_64" /usr/bin/python setup.py build
shell> /usr/bin/python setup.py install

I'm giving the full path for python to make sure it does not use the MacPorts one.

Here a test script test_mysql.py:

import MySQLdb

if __name__ == "__main__":
    db = MySQLdb.connect(host="localhost",
        user="root",db="test")
    cursor = db.cursor()
    cursor.execute("SHOW ENGINES")

    for row in cursor.fetchall():
        print row

    cursor.close()
    db.close()


Run the above script like:

shell> /usr/bin/python test_mysql.py

It should output the available storage engines.

PlanetMySQL Voting: Vote UP / Vote DOWN

This entry was posted on Среда, Сентябрь 23rd, 2009 at 19:07 and is filed under howto, macos, mysql, Python. You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.

Comments are closed.