Replied 3 August 2017, 6:23 am EST
Please refer to the attached project which works correctly at our end with DDR reports bound to MySQL database.
Also, we were able to observe issues at our end as reported by you [u]since the root password contained some special characters[/u].
I suggest you to please set a root password that does not contains any special character. Here is the command for the same :
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('yourpassword')
You may also have a look at the following links wherein similar issues have been discussed :
Hope this helps.
I would like to mention here that this doesn't seems to be a DDR specific issue but a generic issue. Therefore, as a suggestion, you are requested to test the issues against a simple .NET application and see if issues persists while connecting to MySQL database and displaying the data in an MS grid. You may share your observations if the issues seem specific to DDR.