I configured a separate connection to a MySQL-Database. When I click the "Test connection" button the result is ok. Now I saved settings.
When I then click on "Create a table" there is no data (table) to select.
When I switch back to connection and start the test again, it fails with "wpDataTables could not connect to MySQL server. MySQL said: Access denied for user 'root'@'localhost' (using password: YES)".
If I retype the password, the test runs successfully.
Hello,
I configured a separate connection to a MySQL-Database. When I click the "Test connection" button the result is ok. Now I saved settings.
When I then click on "Create a table" there is no data (table) to select.
When I switch back to connection and start the test again, it fails with "wpDataTables could not connect to MySQL server. MySQL said: Access denied for user 'root'@'localhost' (using password: YES)".
If I retype the password, the test runs successfully.
I figured out, that my password was the problem: if it starts with "%" it will not be stored proper.
I think this is a bug and should be solved.
Hi Francesco,
Thank you for your purchase.
Thank you for reporting this, I forwarded this issue to my team and hope that we will have the solution in case it is a bug.
Can you please tell me if you change that % sign is everything working fine.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables