-
Preparations
First Install mysql, then install the odbc driver, I installed mysql-connector-odbc-5.3.4-win32.msi. The following is the link of odbc driver and mysql http://pan.baidu.com/s/1gfodRv9, these two installations are all set by default.
-
Configuration file dsn
, Open the control panel and click on system security and click on management tools.
Then click the 32-bit ODBC data source to set it.
Click Next, it will prompt you to save the file data source name or click Browse, here We click “Browse”. Because this file needs to be used later, it must be placed in a place that is easier to find and then name the file and save it.
Here is just to create the data source, we also need to go back to the file dsn, and then find the file we saved in the previous step, select it and click Configure.
Click OK to complete the configuration file dsn
-
Install powerdesigner
This is also the default for the whole process.
-
Use odbc to connect to mysql
Click Database and then configure connection
Click ODBC File Data Sources, and then click the database icon with the plus sign.
That’s it.
-
Test connection
< /p>