03 - Sep - 2007

DBDesigner4, Windows and MYSQL 5

Posted by Paul Farrow - Under: Software

Ok thought I would have a look at DBDesigner4 as MyWorkbench seems to be taking a long time to get into beta.  DBDesigner4 looks a great product but couldnt get it to connect to mysql 5 then realised that it the designer was designed for version 3 mysql and lots of the old mysql products need to read the myql.user table for id’s etc.

Tried the old trick of using the OLD_PASSWORD function and seems to work what you need to do is this….

1. Open the mysql command prompt.

2. SET PASSWORD FOR 'root'@'localhost' = OLD_PASSWORD('rootpassword');

UPDATE mysql.user SET Password = OLD_PASSWORD('rootpassword') WHERE Host = 'localhost' AND User = 'root';

FLUSH PRIVILEGES;

all in one line – hit return. 

3. Try dbdesigner4 again and you should now be able to connect.