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

kmap

Registered
May 4, 2014
1
0
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
 

cPanelPeter

Technical Analyst III
Staff member
Sep 23, 2013
574
17
143
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.