2 mysql installation issue

  • TomLesters

    TomLesters - 2011-11-07


    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

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



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


Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.

No, thanks