Re: mysql 4.1.9

[Jonathan Monroe <realbasic at actualtechnologies dot com>]

> Allan Kent wrote:
>
> 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');
There is a free, open source OS X application that will do this for 
you, available from our website:
http://www.actualtechnologies.com/password_updater.php

If using pre-4.1 passwords is not possible or practical for you, 
another alternative is to use Actual Technologies' ODBC driver for Open 
Source Databases instead of the RB MySQL plug-in.  The ODBC driver is 
compatible with 4.1 passwords.  It is available for download:
http://www.actualtechnologies.com/download.php

Best regards,

Jonathan Monroe
Actual Technologies - ODBC for OS X
monroej at actualtechnologies dot com

_______________________________________________
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>