Yes, I'm sure it's the password thing.

I already ticked off "old passwords" in the Administrator tool. I think that's equal to starting with "--old-passwords" I restarted the service (and my computer afterwards just to be sure) but it does not help.
I also did a query on it  update mysql.user set password = old_password(..)
I know I'm close to the solution, but I must have forgotten something.

I'll quickly take a look at the plugin anyway.


Peter De Berdt wrote:

On 09 May 2006, at 17:09, Yves Vindevogel wrote:

Hi,

Since the MySQL plugin does not want to talk to MySQL 5, I'm using the ODBC plugin.

Under Windows, I installed the plugin and odbc drivers, but when I want to create a System DSN, I get the error that my password is wrong. I'm very sure it's right, because I type it in the other tools like that as well.

I know it's got something to do with the MySQL password storage way, but I forgot what. I can't retrieve the information anymore, but I'm sure I got an answer here last time ....
So, if anybody could help me out.

Well, as af MySQL 4.1, passwords are stored in a 41 byte hash instead of the old 16 byte hash. Probably that has something to do with your problem. You could instead try Alexander Cohen's CFDatabase:

(pasted from earlier list message)
We've update CFDatabaseBase to 0.2.

What's new:
- support for MySQL 5.0 (CFMySQL)
- support for sqlite 3.3.4 (CFSQLite)

As always, it's available at
<http://www.toomuchspace.com>


Best regards

Peter De Berdt

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



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

Reply via email to