title: Problems installing MySQL-python-1.2.3c1 on Mac Snow Leopard
body: <p>I am having a problem installing the Python MySQL connector (MySQL-python-1.2.3c1) on my Mac OSX Snow Leopard.</p>
  
  <p><strong>System State</strong></p>
  
  <p>I have manually compiled an installed:
  <strong>mysql-5.1.41</strong></p>
  
  <p>This seems to work fine, as I can create and query a database from the commandline.</p>
  
  <p>I have compiled:
  <strong>MySQL-python-1.2.3c1</strong></p>
  
  <p>I first set the following in the <strong>site.cfg</strong> file:</p>
  
  <pre><code>mysql_config = /usr/local/mysql/bin/mysql_config
  </code></pre>
  
  <p>I then built and compiled MySQL-python-1.2.3c1 following their guide:</p>
  
  <pre><code>sudo python setup.py build
  sudo python setup.py install
  </code></pre>
  
  <p>I now test the installation with Python:</p>
  
  <pre><code>python -c "import MySQLdb"
  </code></pre>
  
  <p><strong>Error Message</strong></p>
  
  <p>This then gives me the following error, and I'm stumped as to how to fix it:</p>
  
  <pre><code>Traceback (most recent call last):
    File "&lt;string&gt;", line 1, in &lt;module&gt;
    File "build/bdist.macosx-10.6-universal/egg/MySQLdb/__init__.py", line 19, in &lt;module&gt;
    File "build/bdist.macosx-10.6-universal/egg/_mysql.py", line 7, in &lt;module&gt;
    File "build/bdist.macosx-10.6-universal/egg/_mysql.py", line 6, in __bootstrap__
  ImportError: dlopen(/Users/username/.python-eggs/MySQL_python-1.2.3c1-py2.6-macosx-10.6-universal.egg-tmp/_mysql.so, 2): Symbol not found: _mysql_affected_rows
    Referenced from: /Users/username/.python-eggs/MySQL_python-1.2.3c1-py2.6-macosx-10.6-universal.egg-tmp/_mysql.so
    Expected in: flat namespace
   in /Users/username/.python-eggs/MySQL_python-1.2.3c1-py2.6-macosx-10.6-universal.egg-tmp/_mysql.so
  mymac: username$ 
  </code></pre>
  
  <p><strong>Things I've Tried</strong></p>
  
  <p>I've looked at this blog antoniocangiano.com but it is for an older version of MySQL-python and is not really applicable. But I tried adding the soft link it mentions.</p>
  
  <p>I then looked at this blog post:  <a href="http://blog.some-abstract-type.com/2009/09/mysql-python-and-mac-os-x-106-snow.html" rel="nofollow noreferrer">http://blog.some-abstract-type.com/2009/09/mysql-python-and-mac-os-x-106-snow.html</a>. And tried building compiling with the ARCHFLAGS settings - but no joy.</p>
  
  <p><strong>Please Help</strong></p>
  
  <p>If you have any ideas please let me know.</p>
  
  <p>Many thanks</p>
  
  <p>Ben...</p>