Create Report for mySQL and other database engines without OLE-DB Provider

In MySQL create a separate user from root. You will uses this user in the string below.

ServerIPAddress=xxx.xxx.xxx.xxx
DataBaseName=The database name of interest inside mySQL
MYSQLUserName = The MySQL username provided above
MYSQLUserNamePassword = The Password to the database for the username provided

No spaces between elements.

Database = DatatBaseName
Table = a table within the database.

Dataset should now show table elements.