Connecting MySQL From DBDesigner4
I had a problem connecting mysql from DBDesigner4. Error occurs :
Connection to database failed.
dbExpress Error: Invalid
Username/Password
Username/Password spelled correctly. The problem is because DBDesigner4 was designed for MySQL 3.x.x. For MySQL 4 and higher we have to do the old password trick. This is the solution which is works fine for me. In your terminal, connect to your database:
mysql -u root -p
SET PASSWORD FOR 'root'@'localhost' = OLD_PASSWORD('r00tp45sw0rd');
UPDATE mysql.user SET Password = OLD_PASSWORD('r00tp45sw0rd') WHERE Host = 'localhost' AND User = 'root';
FLUSH PRIVILEGES;
Then you should have no problem connecting to your MySQL servers. You may change the username (root), password (r00tp45sw0rd) & host (localhost) with your own.
* Updated [13/07/2007] – Thanks Raphael.
Posted on July 9th, 2007 by SMD
Filed under: Open Source
I am a Free and Open Source Software lover, advocate. I would like to see Open Source grow, and more users being able to use and understand it. I would like to continue to become a part of this growing community, and to grow with it! 
UPDATE mysql.user SET Password = OLD_PASSWORD(’r00tp45sw0rd’) WHERE Host = ‘localhost’ AND User = ‘root’;
Thanks so much it really help me out i solved my problem good tip, thou i wouldn’t do that on the server ‘cuz of the use of OLD_PASSWORD algorithm