Today, I am working on a project database design. In order to generate a beautiful Data Object Model diagram, I installed dbdesigner 4.
However, when I used it to connect to the MySQL database, I encountered a problem:
Dbdesigner4-dbexpress error invalid username/password.
I remember that I had encountered this problem before and never solved it. I couldn't use it this time, so I went to Google and found a lot of results. It seems that there were quite a few people who encountered the same problem.
Cause:
The password encryption method of MySQL database has changed, and dbdesigner still uses old encryption.Algorithm.
Solution:
Create a new MySQL user and use the old password to encrypt the password:
Grant all privileges on *. * To 'test' @ 'localhost' identified by 'test' with grant option;
Set password for 'test' @ 'localhost' = old_password ('test ');
Dbdesigner connected to MySQL!