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).

• MySQL version is 5.1 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.

---

Whitelist Hevo’s IP Addresses

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

You need to add the 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. Edit the MySQL server configuration file:

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

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

   • To allow any IP4 address to connect to your MySQL Destination, enter:

     bind-address = 0.0.0.0
     

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

     # Example
     bind-address = 10.2.7.152
     

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.

---

Grant Permissions to the Database User

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

Privilege Name	Privilege Description
ALTER	Allows Hevo to edit database tables.
CREATE	Allows Hevo to create databases and tables.
CREATE TEMPORARY TABLES	Allows Hevo to create temporary tables.
DELETE	Allows Hevo to delete rows from database tables.
DROP	Allows Hevo to delete databases and tables.
INSERT	Allows Hevo to insert rows into database tables.
SELECT	Allows Hevo to select rows from database tables.
UPDATE	Allows Hevo to 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> IDENTIFIED BY <user_password>;
   

   Example: To grant privileges on the demo database to the user, jacob from a machine with the IP address 10.0.8.5, enter:

   GRANT ALTER, CREATE, CREATE TEMPORARY TABLES, DELETE, DROP, INSERT, SELECT, UPDATE ON demo.* to jacob@'10.0.8.5' IDENTIFIED BY 'password';
   

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

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

   Example: To view the permissions granted to the user, jacob, enter:

   show grants for jacob@'10.0.8.5';
   

---