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.

updated mysql to 5.6 now i have mysql login problems on ssh

Discussion in 'Database Discussions' started by kmap, May 4, 2014.

  1. kmap

    kmap Registered

    Joined:
    May 4, 2014
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Website Owner
    ERROR 2049 (HY000): Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled)

    mysql works for site but the ssh does not allow me login to mysql ,I get above error
     
  2. cPanelPeter

    cPanelPeter Technical Analyst III
    Staff Member

    Joined:
    Sep 23, 2013
    Messages:
    569
    Likes Received:
    15
    Trophy Points:
    18
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello,

    To correct this you will need to either update the password schema for the user or drop and recreate the user. Before doing any changes it is always a good idea to have backups just in case something was to go wrong.

    The following documentation has clear steps on how to solve this.
     
Loading...

Share This Page