MySQL

Prerequisites

• The MySQL server (not localhost) is running. To check this, enter the following command in your MySQL instance:

  service mysql status
  

  The status must show as Active: active (running).

• The MySQL version is 5.5 or higher. To check this, enter the following command in your MySQL instance:

  mysql -V
  

• Hevo’s IP addresses are whitelisted.

• The necessary privileges are granted to the database user.

• You are assigned the Team Collaborator, or any administrator role except the Billing Administrator role in Hevo to create the Destination.

---

Whitelist Hevo’s IP Addresses

Note: You need root access or sudo privileges to perform some of the commands.

You need to whitelist Hevo IP address(es) for your region in the MySQL configuration file to enable Hevo to connect to your MySQL database.

To do this:

1. Navigate to the MySQL configuration directory. For example, /etc/mysql/mysql.conf.d

2. Open the MySQL server configuration file in edit mode:

   #Example
   sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf
   

   Note: The file path in the command above may vary depending on the location of your server configuration file.

3. Scroll to the [mysqld] section, and update the bind-address variable in one of the following ways:

   • To allow any IPv4 address to connect to your MySQL Destination, specify:

     bind-address = 0.0.0.0
     

   • To allow the specific Hevo IP addresses for your region, specify:

     bind-address = 10.2.7.152
     

     Note: Replace the placeholder value in the command above with your own. For example, <Hevo_IP_address_for_your_region> with 13.235.131.126. Read Selecting your Hevo Region to know the IP address of your region.

4. Save the file, and restart the MySQL server for the changes to take effect.

Note:

• For MySQL versions 8.0 and higher, you need to add the bind-address variable if it does not exist in the [mysqld] section.

• Delete or comment out any line with the skip-networking variable in the configuration file, as this variable does not allow the MySQL server to listen for remote connections.

---

Create a Database User and Grant Privileges

1. Create a database user

Perform the following steps to create a user in your MySQL database:

1. Log in to your MySQL database instance as a root user, using an SQL client tool.

2. Enter the following command:

   CREATE USER '<user_name>'@'%' IDENTIFIED BY '<strong password>';
   

   Note: Replace the placeholder values in the command above with your own.

2. Grant privileges to the user

The following table lists the privileges that Hevo requires to connect to and load data into your MySQL Destination:

Privilege Name	Allows Hevo to
ALTER	Edit database tables.
CREATE	Create databases and tables.
CREATE TEMPORARY TABLES	Create temporary tables.
DELETE	Delete rows from database tables.
DROP	Delete databases and tables.
INSERT	Insert rows into database tables.
SELECT	Select rows from database tables.
UPDATE	Update rows in database tables.

Perform the following steps to grant the privileges:

1. Log in to your MySQL server as a root user. For example, mysql -u root -p.

2. Enter the following command to grant privileges to the database user:

   GRANT ALTER, CREATE, CREATE TEMPORARY TABLES, DELETE, DROP, INSERT, SELECT, UPDATE ON <database_name>.* to <user_name>@<IP address>;
   

   Note: Replace the placeholder values in the command above with your own. For example, <user_name> with jerome.

3. (Optional) View the grants for the user with the following command:

   show grants for <user_name>@<IP address>;
   

   Note: Replace the placeholder values in the command above with your own. For example, <user_name> with jerome.

---