Finally i found a fabulous Database design tool which is really does the work. Please try this and have fun with it.
http://www.fabforce.net/dbdesigner4/index.php
I have solved this problem by converting password for a
user that is used to connect from DBDesigner to MySQL to an old pre-4 (See http://pre-4.ora-code.com).0
passwords type. Someone in one of MySQL lists posted solution a few
months ago.
For conversion use, from MySQL manual:
“Reset the password to pre-4 (See http://pre-4.ora-code.com).1 style for each user that needs to use a
pre-4 (See http://pre-4.ora-code.com).1 client program. This can be done using the SET PASSWORD
statement and the OLD_PASSWORD() function:
mysql> SET PASSWORD FOR ’some_user’@’some_host’ = OLD_PASSWORD(’newpwd’);
Alternatively, use UPDATE and FLUSH PRIVILEGES:
mysql> UPDATE mysql.user SET Password = OLD_PASSWORD(’newpwd’) WHERE Host = ’some_host’ AND User = ’some_user’;
mysql> FLUSH PRIVILEGES;”
http://dev.mysql.com/doc/mysql/en/old-client.html
