mysql_set_character_set undefined symbol

[Force]

server:~/MySQL-python-1.2.2# python test_MySQLdb_capabilities.py
/usr/local/lib/python2.4/site-packages/MySQL_python-1.2.2-py2.4-linux-i686.egg/_mysql.py:3: UserWarning: Module _mysql was already imported from /usr/local/lib/python2.4/site-packages/MySQL_python-1.2.2-py2.4-linux-i686.egg/_mysql.pyc, but /root/MySQL-python-1.2.2 is being added to sys.path
Traceback (most recent call last):
File "test_MySQLdb_capabilities.py", line 4, in ?
import MySQLdb
File "/root/MySQL-python-1.2.2/MySQLdb/init.py", line 19, in ?
import _mysql
File "build/bdist.linux-i686/egg/_mysql.py", line 7, in ?
File "build/bdist.linux-i686/egg/_mysql.py", line 6, in bootstrap
ImportError: /root/.python-eggs/MySQL_python-1.2.2-py2.4-linux-i686.egg-tmp/_mysql.so: undefined symbol: mysql_set_character_set
server:~/MySQL-python-1.2.2#

I got this message while attempting to test the mysqldb capabilities
I tried all versions of python, i've modified the site.cfg files and I'm running out of ideas. What else can cause this?

[Andy Dustman]

Something's wrong with your build, or you aren't loading the version of _mysql.so that you expect after an upgrade.