Skip to main content

MySQL

This guide shows you how to create a MySQL Connection in Ascend.

Prerequisites​

  • Ascend Project
  • Ascend Project
  • Ascend Workspace
  • Credentials for your MySQL database
    • Username: Username of the account used to connect to the MySQL server
    • Password: Password of the account used to connect to the MySQL server
  • Optional: If you are using an SSH tunnel, follow the steps in Setting up an SSH Tunnel.
  • Optional: If you would like to enable SSL, follow the steps in Setting up SSL.

Create a MySQL Connection

From your workspace Super Graph view, follow these steps:

  1. Create a Connection by either:
    • Clicking the + button next to Connections in the left Build panel
    • add-connection
    • Right-clicking in the Super Graph and selecting Create Connection
    • menu
  2. Enter a descriptive name like `read_mysql`
  3. Select MySQL from the available options
  4. Fill in the required fields (and any optional fields as needed)
  5. Click Save at the bottom to create your Connection
  6. form

For complete configuration options, see our Connection reference guide.

Example​

Use the following YAML template for your MySQL Connection. Customize the highlighted placeholder values with your specific Connection details:

/my_project/connections/mysql_connection.yaml
connection:
mysql:
host: <hostname>
port: 3306 # default value is 3306, can modify as needed
database: <database>
user: <username>
password: "${vaults.<your_vault>.<password>}"

🎉 Congratulations, you just set up a MySQL Connection in Ascend!