Results 1 to 4 of 4
  1. #1
    Join Date
    May 2007
    Posts
    87

    Unhappy problem with MYSQL

    hi,

    i have a problem with MYSQL i upgraded php to 4.4.7

    i got problem with all my sites have database running

    mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Client does not support authentication protocol requested by server; consider upgrading MySQL client
    /home/site/public_html/forum/includes/class_core.php on line 273

    THE MYSQL version mysql Ver 14.7 Distrib 4.1.22, for pc-linux-gnu (i686) using readline 4.3

    i running php 4.4.7 and apache 1.3.39 with WHM 11.11.0 cPanel 11.16.0-S18450

    so i was hope anyone Help Me With that problem

    thanks,

  2. #2
    You should run mysql in old password mode .
    In WHM under 'Tweak Settings' check this one :

    Use old style (4.0) passwords with MySQL® 4.1+ (required if you have problems with PHP apps authenticating)
    Http.co.il - Web Hosting Solutions

  3. #3
    Join Date
    May 2007
    Posts
    87
    well i solved the problem with recompile apache and check the following setting

    Mbstring
    Mcyrpt
    Mysql of the system

    and i looked in ur solution and i found

    Use old style (4.0) passwords with MySQL® 4.1+ (required if you have problems with PHP apps authenticating)

    not check and i checked it and i save the setting now

    should i recompile apache again and un check this settings

    Mbstring
    Mcyrpt
    Mysql of the system

    waiting for ur reply,
    thanks,

  4. #4
    Join Date
    Oct 2004
    Location
    Kerala, India
    Posts
    4,771
    If the database uses the old style password hash you need to check that option. To determine that, follow the steps.

    Enter into mysql prompt from ssh. Type the following commands.

    Code:
    use mysql
    select Password from user where User='database_username';
    If you see the something like this, it uses old style password.
    Code:
    +------------------+
    | Password         |
    +------------------+
    | 158d196829124dc3 |
    If you see something like below it uses new style

    Code:
    +-------------------------------------------+
    | Password                                  |
    +-------------------------------------------+
    | *3580E9208A941CDE651A4ECEE1EC5B49BDF08832 |
    +-------------------------------------------+
    David | www.cliffsupport.com
    Affordable Server Management Solutions sales AT cliffsupport DOT com
    CliffWebManager | Access WHM from iPhone and Android

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •