I'm not able to connect the tool DBDesigner to MySQL . When I try to connect, the message appears:
dbExpress: Invalid Username / password
I found in some forums the suggestion to type at the MySql prompt the following command "mysql>SET PASSWORD FOR 'user'@'host' = OLD_PASSWORD('password');"
I tried and I get an error message:
ERROR 1372 (HY000): PASSWORD hash should be a 41-digit hexadecimal number
Could someone help me?