MySQL

To securely connect Explorazor to your MySQL database and retrieve data -

1. Click Datasets and select Add New from top right
2. Under Database Connections click Connect MYSQL DB
3. Connect to your MySQL database by entering the requested information in the fields -
4. Click the False option for Live Connection. Once all the fields are filled click Select Tables to choose from the tables you want to upload to Explorazor
5. Select Data by choosing from a list of tables within your database. Check the boxes next to the tables you want and click Select Columns
6. To choose from the columns availble in the tables selected Select All if you want all the columns or check the boxes next to the columns you want to include and click Confirm
7. Data retrieved from your MySQL database will get stored as a dataset in Explorazor with the relevant timestamp reflecting the date and time of upload and refresh