Connecting to MySQL
- 31 May 2022
- 1 Minute to read
- Print
- DarkLight
Connecting to MySQL
- Updated on 31 May 2022
- 1 Minute to read
- Print
- DarkLight
Article Summary
Share feedback
Thanks for sharing your feedback!
Note
This documentation is prior to May 2022.
Connecting to MySQL
There are three options to connect to MySQL:
- Create a new project
- Edit an existing project connection
- Export data from the Export >Run recipe button
Connecting to MySQL when Creating a New Project
- Click Enrich. The Enrich page is displayed.
- Click
in the upper-right hand corner. The Create a new project window is displayed.
- Type in a new project name. The project name needs to be unique.
- Select a use case from the drop-down.
- Click Create project. The Upload a dataset window appears.
- Select MySQL. The following screen is displayed for a new database connection creation:
- All the fields are mandatory. Choose a connection name.
- Type in the Host.
- Type in the Port number.
- Type in the Database name.
- Type in the User name.
- Type in the Password.
- Type in the Temp Schema.
- Click Create. A message is displayed that the connection was successfully created. If the test connection failed, then you are unable to create a connection.
Connecting to MySQL when Editing a Dataset
- Click Enrich. The Enrich page is displayed.
- Create or search for a project.
- Click
.
- The Change data and edit dataset window is displayed.
- Click Continue.
- Select MySQL. The following screen is displayed for a new database connection creation:
- All the fields are mandatory. Choose a connection name.
- Type in the Host.
- Type in the Port number.
- Type in the Database name.
- Type in the User name.
- Type in the Password.
- Type in the Temp Schema.
- Click Create. A message is displayed that the connection was successfully created. If the test connection failed, then you are unable to create a connection.
Exporting Data
- Click Enrich. The Enrich page is displayed.
- Create, search or edit a project.
- Click the Export >Run Recipe.
- The Schedule Recipe Run window is displayed.
- Select the input connection (optional).
- Select the output connection.