I found the answer.
MySQL 4.1 uses a newer authentication protocol not supported by older mysql
clients. CFMX uses the older type of client for connecting to MySQL.
The workaround is to convert the user account on the MySQL 4.1 server to use
"OLD_PASSWORDS"
This can be done by simply:
mysql> UPDATE user SET Password = OLD_PASSWORD('mypass')
-> WHERE Host = 'some_host' AND User = 'some_user';
mysql> FLUSH PRIVILEGES;
or, if you feel happy enough for all acounts on your MySQL 4.1 server to use
the older authentication protocol, then simply startup with
the --old-passwords option.
HTH someone in future.
Dave
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
