Got it ....
1) Tick off the box in the MySQL Administrator under Security to allow
old passwords
2) Change password of your user with (something like)
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPassword');
Yves Vindevogel wrote:
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>
_______________________________________________
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>
