Follow the steps below to connect to a MySQL table or view:

 

Bring up the Data Source Creation Wizard, by navigating to File->Create New Data Source.

 

Connect to MySQL 5.0 or higher, by clicking on MySQL 5.0.

 

Set required connectivity information, including the server address, the username and password as well as the name of the database you wish to connect to.  Then click OK.

 

Finally, select the table or view from the list and click OK.  To preview the table, enable the Preview checkbox.

See Also