Tell the server to use the older password hashing algorithm:
1. Start mysqld with the --old-passwords option.
Assign an old-format password to each account that has had its password updated to the longer 4.1 format. You can identify these accounts with the following query:
2. mysql> SELECT Host, User, Password FROM mysql.user -> WHERE LENGTH(Password) > 16;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near '16' a
t line 3