my problem is I have an old default mysql 3.23 installed by rpm that's
controlled by root.
I only have my normal user account and installed in my user account a new
mysql 5.5 version.
the mysql server/client is working ok, but when I try to use python to connect
seems MySQLdb is using the old 3.23 version libfile/conf file etc. and throw
out a set of errors.
File '/usr/share/mysql/charsets/?.conf' not found (Errcode: 2)
Character set '#33' is not a compiled character set and is not specified in
the '/usr/share/mysql/charsets/Index' file
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "build/bdist.linux-i686/egg/MySQLdb/init.py", line 81, in Connect
File "build/bdist.linux-i686/egg/MySQLdb/connections.py", line 187, in
_mysql_exceptions.OperationalError: (1251, 'Client does not support
authentication protocol requested by server; consider upgrading MySQL client')
my question is when I use python setup.py build/install how do I instruct
MySQL-python-1.2.3 to use the newer version mysql client/lib/my.cnf file?
my mysql 5.5 installation dir is :
in site.cfg , I tried to set
mysql_config = /home/tom/pkgs/mysql5.5/mysqlbuild/bin/mysql_config
but to no avail
Anybody can shed some light on this?
You can easily install mysql python and after installing it, you will get rid
of every short of errors, you are getting now. For more information regarding
this could be found from the following link :