DBDesigner4 connection to MySQL5 Problems and Solutions

Today, I am working on a project's database design. To generate a beautiful Data Object Model diagram, I installed DBDesigner4. But when I used it to connect to the MySQL database, I encountered a problem: DBDesigner4

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.

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 the 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!