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.