2 mysql installation issue

Help
TomLesters
2011-11-07
2012-09-19
  • TomLesters
    TomLesters
    2011-11-07

    hi,

    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
    to mysql,

    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
    init

    _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 :

    /home/tom/pkgs/mysql5.5/mysqlbuild/

    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?

    thanks,

    Tom

     
  • steffy tailor
    steffy tailor
    2011-12-24

    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 :
    http://www.mysqlpython.com