MySQL

Getting Started with MySQL Destination Configuration

Requirements:

• Active MySQL database instance.

• Allow connections from DataBrain to your MySQL database.

  • For details on setting up IP whitelisting and ensuring secure connectivity, refer to our guide on

Allow Access to our IP

• Choose the DataBrain Workspace to which you wish to connect the data.

Setup Guide:

1. Ensure Database Accessibility:

   • Ensure your MySQL database is active and accessible from the machine running DataBrain.

   • Accessibility is dependent on your MySQL user privileges and network settings. The easiest way to verify if DataBrain can connect to your MySQL database is via the check connection tool in the UI. For detailed setup and permissions, refer to the MySQL documentation.

2. Grant Necessary Permissions:

   • Read Access on Tables and information_schema: Grant read access permissions to the tables within MySQL as well as the information_schema schema. This allows DataBrain to retrieve necessary information and replicate data accurately. You can assign appropriate permissions to the user or role accessing MySQL to enable reading from tables and accessing metadata stored in the information_schema. -- Grant SELECT permission on all tables in the specified schema GRANT SELECT ON <schema_name>.<table_name> TO <username>

3. Fill Up Connection Info:

   • Provide the necessary information to connect to your MySQL database:

     • Destination Name: [Pick a name to help you identify this destination in DataBrain]

     • Host: [Enter your MySQL account locator]

     • Port: 3306 (This is the default port for MySQL databases)

     • Username: [Enter the name of the user you want to use to access the database]

     • Password: [Enter the password associated with the username]

Encryption:

• Ensure you have SSL/TLS set up for your MySQL database if you require encrypted connections from DataBrain for enhanced security.

Permissions:

• Permission to read information_schema.

• Whitelist the IP address.

• Grant read access to the schema (usage) and tables, noting that access to only tables may not suffice in certain databases.

Replace the placeholders inside the square brackets with actual values when filling in the details.

Locating the Configuration Details in MySQL

1. Destination Name:

   • This is a custom name you decide for identification within DataBrain. Choose a name that is relevant to your MySQL setup.

2. Host:

   • For remote servers, it would be the IP address or domain name of the machine where MySQL is running.

   • If you have access to the MySQL shell, you can also use the command SHOW VARIABLES WHERE Variable_name = 'hostname'; to retrieve the hostname.

3. Port:

   • The default port for MySQL is 3306. However, this can be customized. If you're in the MySQL shell, you can use the command SHOW VARIABLES WHERE Variable_name = 'port'; to check the port MySQL is running on.

4. Username:

   • The username is the one you use to log in to the MySQL shell. If you're logged in, you can use the command SELECT USER(); to display the current user.

5. Password:

   • The password is associated with your MySQL username. MySQL does not provide a direct method to view passwords due to security reasons. If you've forgotten the password, you'll need to reset it or consult your database administrator.