MYSQL Problems after Update from MySQL

Discussion in 'General' started by PierreR32, Mar 9, 2007.

  1. PierreR32

    PierreR32 New Member


    first sorry for my bad english.
    I have updated on my Debian System the Database from 4.0.24 to 4.1.11. Ok after the Update are running all Databases with not problems.
    Last Wensday i updated ISP at acually version.
    Now my problem.

    when a customer create a new Database is not running the script with username and Password !!!
    He became the error:
    Warning: mysql_connect() [function.mysql-connect []]:
    Client does not support authentication protocol requested by server; consider upgrading
    MySQL client in */var/www/webxxx/files/dbconnect_h.php* on line *15*
    Konnte keine Verbindung zur Datenbank herstellen
    so. I have search in google and found a german fix for this problem, but its running for one user ! When the user create a new password came the error back.
    But i have not the time for change via console the password :eek:

    My ask.
    What is the Problem ?
    All old Databases and Password running with no problems. Only new create Database make trouble.
    Please help me.

  2. till

    till Super Moderator Staff Member ISPConfig Developer

    The problem is that mysql versions 4.x and 4.1.x use incompatible passwords. Please update the php mysql package on your server or activate the old-passwords optin in the php my.cnf file.
  3. PierreR32

    PierreR32 New Member

    ok thx thats running ... but iam understand why run only the old Passwords ... but its ok ;)

  4. Hans

    Hans Moderator ISPConfig Developer

Share This Page