Connecting MySQL From DBDesigner4

Open Source 9 July 2007 5 Comments



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.



  • http://www.webspin.biz Raphael

    UPDATE mysql.user SET Password = OLD_PASSWORD(‘r00tp45sw0rd’) WHERE Host = ‘localhost’ AND User = ‘root’;

  • http://www.blognecronet.blogspot.com Necronet

    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

  • Suzann

    ‘terminal’ means ‘server’?

  • SMD

    Terminal means application to run command line. In Linux, search for terminal applications.

    note: the software is old. change to MySQL Workbench.

  • csr

    great! worked for me.