mySQL OLD_PASSWORD

[Ruslan Zasukhin]

On 2/28/13 2:09 AM, "Kay C Lan" <lan.kc.macmail at gmail.com> wrote:

Hi Kay,

> Back in March 2006, when I upgraded to mySQL 5.0, Rev (now LiveCode) could not
> handle the new password algorithm, so you had to use the OLD_PASSWORD format.
> I see my passwords are still in the old format.
> 
> Just downloaded the free Valentina Studio (thanks guys) and test running it.
> Great with Val dbs, no problems with SQLite, but when I try to access my
> localhost mySQL server I get:
> 
> drizzle_state_handshake_result_read:old insecure authentication mechanism no
> supported
> 
> I'm assuming this is because I'm still using the OLD_PASSWORD format.
> 
> So, does anyone know if LiveCode can now handle the NEW mySQL password format?
> 
> Is there any work around to get Val Studio 5.0 to work with OLD mySQL
> passwords?

Most probably this is issue of mySQL itself.

Most probably can be googled info how convert existed users into new format
...

But it seems Sergey told me, no automatic way, because mySQL keps not
passwords itself, but some hash ... So no way convert that

You need only 

A) change some flag in mySQL to start use new format
B) add all users again with their login/passw pairs...


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]