18
Sep
stored in: General and tagged:

I use DBDesigner4 for DB modeling and ERD generation. Great tool, though the original developer went to work for MySQL (I think) to build their MySQL Workbench. Well, for Linux users, Workbench isn’t available yet, so we can still use DBDesigner4, which works great. Anyways, so I recently attempted to connect to my local MySQL 5 instance, and couldn’t connect. Consistent errors stating invalid username/password, even though I clearly typed it with no errors.

The issue is rather simple. The library used by DBDesigner4 uses an older version of the MySQL API to connect. Meaning, in between versions, MySQL changed the method by which passwords are stored, therefore the authentication would keep failing. Enter ‘OLD_PASSWORD‘. By setting your password using the ‘OLD_PASSWORD’ method, you can connect up with DBDesigner.

Example:

mysql> set password for ‘user’@’host’ to OLD_PASSWORD(‘mysecret’);

2 Responses to “DBDesigner4 & MySQL 5”

  1. Alessandro Says:

    Hi!
    I tried to type this command but it doesn’t work.

    The following commang work fine:
    set password for ‘user’@’host’ = OLD_PASSWORD(’mysecret’);

    Regards

    Alessandro

  2. Sabine Says:

    Hi!

    I try this for quite some time now – I can reset the password with the OLD_PASSWORD() function – I can see it is different to the other passwords set on other users – BUT – I cannot connect!
    The error remains the same .
    Any recent suggestions what I can do?

    Regards
    Sabine

Leave a Reply