Detailed instructions to help you set up the data source for MySQL
Lastly modified on: Thu, 20th June, 2024 at 03:45 PM
Prerequisites
- MySQL database
- MySQL account with a read right.
- MySQL account allowed to connect remotely to the database from the IP address: 52.79.160.224.
- Check the rights of your MySQL user.
Instructions
- Move to Adriel’s Connections page.
- Type “MySQL” into the search bar.
- Fill in the five required and optional fields accordingly to the database that you want to connect to Adriel.
- Host: Database host name
If your database is hosted behind a firewall, whitelist the following IP address: 52.79.160.224.
Check the settings of your hosting machine or your hosting provider.
- (Required)Database: Database name you want to import
- (Required)User: name of a user allowed to read data and connect to your database.
- (Required)Password: Password of your MySQL user account.
- (Required)Port: Database port; default port of MySQL is 3306
- (Optional)Alternative Channel Name: Alternative name for the data source
- No icon is provided as a default for this feature. However, there are channels that can use internally saved icons and display next to the channel name you just wrote down.
- Refer to this guide to input the correct name to display the icon.
https://academy.adriel.com/en/how-to-set-alternative-channel-name-for-file-db-data-source - Click the “Submit” button below to complete the data connection.