MySQL client libraries
dcragg at lacscentre.co.uk
Tue May 10 12:29:50 EDT 2005
On 10 May 2005, at 16:00, Chris Sheffield wrote:
> I have a big problem that I need to figure out ASAP one way or
> I installed the latest version of MySQL on my Mac OS X Tiger
> machine (MySQL version 4.1.11 I believe). Now my application isn't
> working. Upon trying to connect to my database I'm getting an
> error that says, "Client does not support authentication protocol
> requested by server; consider upgrading MySQL client". I remember
> running into this at one point in the past, but I don't remember if
> I got around it somehow or if it was just with the release of Rev
> 2.5.1 that it was fixed.
> So my first question is, is it possible to update the MySQL client
> libraries (dll's, OS X bundles, etc.) that come with Revolution?
> Can they be downloaded somewhere? If not, does anyone know of a
> way to completely uninstall MySQL from OS X and reinstall an older
> version? I've tried following the downgrading instructions in the
> MySQL manual, and all they say is to just install the older version
> right over the top of the newer version, so long as it's the same
> release (4.x in this case). But when I try to do that, the
> installer tells me I can't install because a newer version already
> exists. Any way to "trick" the OS X installer into letting me
> install the older version?
I got round this by resetting the user passwords on the newer server
using the OLD_PASSWORD function.
SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('mypass');
More information about the Use-livecode