Xojo Conferences
XDCMay2019MiamiUSA

mysql 4.1.9 (Real Studio network user group Mailinglist archive)

Back to the thread list
Previous thread: REALmidi Plugin? (Was: Noteplayer Drum Sounds in Win32)
Next thread: Error Message...Help.


mysql 4.1.9   -   Marc Van Olmen
  Re: mysql 4.1.9   -   Allan Kent
  Re: mysql 4.1.9   -   Bob Keeney
  Re: mysql 4.1.9   -   Jonathan Monroe

mysql 4.1.9
Date: 31.01.05 05:34 (Sun, 30 Jan 2005 23:34:59 -0500)
From: Marc Van Olmen
Hi,

I just was doing some tests today, and maybe this is a FAQ... sorry
then.

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.

Is there anywhere a more recent version of the "MySQL Plugin.rbx"
available or is there a work arround.

I created currently a user with no password and in that case the "MySQL
Plugin.rbx" works

thx,

mvo

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

Re: mysql 4.1.9
Date: 31.01.05 06:54 (Mon, 31 Jan 2005 07:54:35 +0200)
From: Allan Kent
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>

Re: mysql 4.1.9
Date: 31.01.05 15:23 (Mon, 31 Jan 2005 08:23:15 -0600)
From: Bob Keeney
MySQL 4.1 changed the way they handle passwords. To get the existing
plugin to work with the new way you'll have to use the following in the
MySQL command line:

set password for 'your user name' = Old_Password('password');

Where your user name (keep the quotes) is the db user you've setup and
password (again, keep the quotes) is the password you set for that db
user.

There may be other workarounds but this one works fine for my customers.

Cheers,
Bob Keeney
BKeeney Software Inc.

> Hi,
>
> I just was doing some tests today, and maybe this is a FAQ... sorry
> then.
>
> 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.
>
> Is there anywhere a more recent version of the "MySQL Plugin.rbx"
> available or is there a work arround.
>
> I created currently a user with no password and in that case the "MySQL
> Plugin.rbx" works
>
> thx,
>
> mvo

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

Re: mysql 4.1.9
Date: 31.01.05 16:25 (Mon, 31 Jan 2005 09:25:48 -0600)
From: Jonathan Monroe
> 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
<email address removed>

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