MySQL

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

1. Click Data and select New Data Connections from the left navigation bar
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 transfer to Phrazor
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 Phrazor with the relevant timestamp reflecting the date and time of upload and refresh