Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

How I solved ERROR 1251: Client does not support authentication protocol requested

Discussion in 'General Discussion' started by Radio_Head, Feb 1, 2006.

  1. Radio_Head

    Radio_Head Well-Known Member

    Joined:
    Feb 15, 2002
    Messages:
    2,051
    Likes Received:
    1
    Trophy Points:
    343
    How I solved the problem

    ERROR 1251: Client does not support authentication protocol requested by server; consider
    upgrading MySQL client


    I am posting here the how to because nothing in this forum worked execpt of this step by step procedure.


    Problem : when you execute mysql from command line you receive "ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client"

    1) /scripts/mysqlup --force

    2) open /etc/my.cnf and add

    old-passwords

    on [mysqld]

    3) #service mysql restart

    4) now open WHM and change your mysql root password
    (I used a 8 chars password)


    Only now, it should work !


    In several posts in this forum I read add old-passwords on my.cnf . It was not enough for me . Only the procedure above fixed my problem definitely.


    Bye
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  2. Alexandre

    Alexandre Member
    PartnerNOC

    Joined:
    Jan 21, 2004
    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    151
    Location:
    U.S.A.
    You can try

    #mysqld_safe --skip-grant-tables --old-passwords &
    #mysql -u root
    #mysql>UPDATE mysql.user SET Password=PASSWORD('yournewpasswd')
    -> WHERE User='root';
    mysql> FLUSH PRIVILEGES;

    Replace "yournewpasswd"' with the actual root password that you want to use.

    ;)
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. aliali

    aliali Registered

    Joined:
    Sep 15, 2007
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    51
    Alexndere

    thank you very much

    it took me 4 days of searching untill found this way

    thanks man
     
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice