Database Error

mickalo

• August 06, 2015 10:42

Hello, did some searching here but couldn't find an answer. we recently upgraded our Mysql to 5.6 all is going well so far but I have one account, using Perl to connect to database & updated their password from the old style, but keep getting this error:
DbError: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled)
We have other Perl programs running without any issues. What is the correct fix for this issue? Thank you,

• 

  mickalo

  • August 06, 2015 16:17

  I found the problem there is a column setting in the mysql.user table under 'plugin' that had to be changed also so it uses the native password and not the old style password. Mike

  0
• 

  cPanelMichael

  • August 06, 2015 19:21

  Hello :) I'm happy to see the issue is now resolved. Thank you for updating us with the outcome.

  0

Please sign in to leave a comment.