Heya,
Marc Van Olmen wrote:
but when I try to connect with a password user to the mysql server it
saids the client isn't running the right version of the mysql client
library and needs to be upgraded.
MySQL 4.1 and above uses a different method (longer) of hashing
passwords. So when you create a user, it will be default use the new
style of password hashing, which the MySQL client, and any older MySQL
utility, will fail to authenticate with. The workaround is to set the
password for the user account with the OLD_PASSWORD() function. So for
example if your user name was 'rb_mysql' and you allowed the user to
connect from only the local host, and you wanted the password to be
'REAL', then you would normally set the password at the mysql prompt with:
mysql> SET PASSWORD FOR 'rb_mysql'@'localhost' = PASSWORD('REAL');
but now with you wanting to connect to MySQL 4.1 with an older client
version, use
mysql> SET PASSWORD FOR 'rb_mysql'@'localhost' = OLD_PASSWORD('REAL');
I created currently a user with no password and in that case the
"MySQL Plugin.rbx" works
because without any password, the hashing difference is not an issue.
Allan
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
|