[categories] [index] [all (553)] [latest]

1. Use the former password system

   Since version 4.1, MySQL stores password in a new way.

   Previous clients can't authenticate anymore.

   As a workaround, you can update user passwords in mysql.user table:

   mysql> UPDATE mysql.user SET password = OLD_PASSWORD('password') WHERE user = 'xxx' and host = 'xxx';
   mysql> FLUSH PRIVILEGES;