MySQL

This guide provides step-by-step instructions for connecting MySQL to Unistream.

Prerequisites

You will need:

• Access to your MySQL instance

• Administrator privileges to create a new user (or existing user credentials)

• Host address and port number

• Unistream platform credentials

---

Step 1: Configure Access in MySQL

Before connecting to Unistream, you need to create a dedicated user in MySQL and grant appropriate permissions.

1.1 Create User

Connect to your MySQL instance (using mysql client, MySQL Workbench, or another tool) and run the following commands:

-- Create a new user with password
CREATE USER '<username>'@'%' IDENTIFIED BY '<password>';

Replace:

• <username> with your desired username

• <password> with a secure password

• % allows connections from any host. For better security, replace with specific IP address

1.2 Grant Permissions

Choose the appropriate permission level based on your needs:

Option A: Grant Access to Entire Database

-- Grant read access to all tables in the database
GRANT SELECT ON <database>.* TO '<username>'@'%';

-- Apply the changes
FLUSH PRIVILEGES;

Replace:

• <database> with your database name

Option B: Grant Access to Specific Tables

-- Grant select on specific tables
GRANT SELECT ON <database>.<table1> TO '<username>'@'%';
GRANT SELECT ON <database>.<table2> TO '<username>'@'%';

-- Apply the changes
FLUSH PRIVILEGES;

Replace:

• <database> with your database name

• <table1>, <table2>, etc. with your table names

Option C: Grant Access to Specific Columns

-- Grant select on specific columns
GRANT SELECT (<column1>, <column2>, ...) ON <database>.<table> TO '<username>'@'%';

-- Apply the changes
FLUSH PRIVILEGES;

Replace:

• <database> with your database name

• <table> with your table name

• <column1>, <column2>, etc. with your column names

1.3 Example: Complete Setup

Here's a complete example for a database named sales:

-- Create user
CREATE USER 'unistream_user'@'%' IDENTIFIED BY 'SecureP@ssw0rd123!';

-- Grant read access to all tables in the database
GRANT SELECT ON sales.* TO 'unistream_user'@'%';

-- Apply the changes
FLUSH PRIVILEGES;

---

Step 2: Connect to Unistream

2.1 Add MySQL Source

1. In Unistream, navigate to Lake

2. Click Add Source

3. Select MySQL

2.2 Configure Connection

Fill in the General Fields:

• Name: Enter a descriptive name for your connection (e.g., "Production MySQL")

• Code: Enter a unique code identifier (e.g., "prod_mysql")

Fill in the Connection Details:

• Host: Your MySQL server address

• Port: MySQL port (default: 3306)

• Username: The username you created in Step 1 (e.g., unistream_user)

• Password: The password you set in Step 1

• (Optional) Database: The name of the database you want to connect to (e.g., sales)

2.3 Test and Save

1. Click Test Connection to verify the connection is working

2. If the connection is successful, you'll see a success message

3. Click Add to save your connection

Need Help?

If you encounter any issues not covered in this guide, please contact Unistream support