How To use MySQL without old passwords

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
itsds
Posts: 37
Joined: Mon 30 Apr 2007 10:38
Location: Germany - Bochum
Contact:

How To use MySQL without old passwords

Post by itsds » Tue 12 Mar 2013 10:08

Since MySQL V 5.6.10 the old-password option is disabled by default.

What have i got to do to use UniDAC MySQL with the new Password Format.
I tried it with the Demo App to connect to the Server but failed.
Is there a special Option to set ?

I forgot i use the latest unidac Version

best regards
Stefan

DemetrionQ
Devart Team
Posts: 271
Joined: Wed 23 Jan 2013 11:21

Re: How To use MySQL without old passwords

Post by DemetrionQ » Wed 13 Mar 2013 12:46

Hello.

The old password format is used only in MySQL servers till version 4.1. The detailed information on the password format in MySQL servers can be found at http://dev.mysql.com/doc/refman/5.5/en/ ... shing.html . Since version 4.1 and higher, UniDAC works with MySQL servers via the new password format. If the password is stored in the database in the new format, you mustn't have problems with connection.
Please describe the problem in more details.

frisk896
Posts: 1
Joined: Mon 24 Jun 2013 12:20

Re: How To use MySQL without old passwords

Post by frisk896 » Mon 24 Jun 2013 12:25

Old style password is used when mysql5 is installed and you have old passwords from mysql4.
Using old style passwords under mysql4 is pointless.If you upgraded from mysql4 to mysql5 then you should enable that option.Cpanel will not enable it or disable it on it's own based on upgrades or downgrades.

Post Reply