The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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:
    38
    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
     
  2. Alexandre

    Alexandre Member
    PartnerNOC

    Joined:
    Jan 21, 2004
    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    1
    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.

    ;)
     
  3. aliali

    aliali Registered

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

    thank you very much

    it took me 4 days of searching untill found this way

    thanks man
     
Loading...

Share This Page