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.