OK - so just want to get started and create charts using data from the WP database.

I've created a MYSQL connection - but switching I get this error. (screenshot 1).

When I generate a code through the 'Generate a query to MySQL database' I get an output.  However, when I click create a table, I get a white page with the date in the corner. (screenshot 2 and 3)

Interestingly when I take the code and place it directly in phpmyadmin the code doesn't work.  

When I take a code that works from phpmyadmin - it doesn't work either (get the same white screen with date).

Also, different from your videos, I don't get a MySQL option only SQL option. (screenshot 4).

I've been at this for hours, on my local dev site and trying on my live site.

For completeness - setup(s)

Live: MySQL 5.5.5 and php 7.3.15

Local: MySQL 5.7.26 and php 7.3.9

I look forward to hearing form you.  Thanks

Ashley

OK - as is typical.  In less than 10 minutes after posting this, figured out that need to whitelist against the security plugin I have installed!  Hope this helps anyone who might struggle in the future!