MySQL 4 and 5 on same box, HOWTO?

Help
BDGENZ
2010-06-22
2012-09-19
  • BDGENZ
    BDGENZ
    2010-06-22

    Have mysql4 and MySQLdb 1.2.0 working together.

    I install mysql5, use port 3307and grabbed MySQLdb 1.2.3

    Appears to built against default mysql4 (location) as it returns:

    File "/usr/lib64/python2.4/site-packages/PIL/init.py", line 81, in Connect

    File "build/bdist.linux-x86_64/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')

    Howto build against mysql5?

    TIA

     
  • Andy Dustman
    Andy Dustman
    2010-06-22

    Make sure the correct mysql_config is on your path and it should build fine. I
    seem to remember you can set the path to it in site.cfg; check setup_posix.py
    for details.

     
  • BDGENZ
    BDGENZ
    2010-06-22

    Yep, set the path to mysql in site.cfg before posting here.