Skip to main content
This article guides you through the process of connecting MySQL to Upsolve, allowing you to seamlessly access your MySQL data within the Upsolve platform. Note: Users can establish a data source to their MySQL database on AWS by leveraging IAM credentials. For more details, refer to the article on Upsolve’s documentation.

​
Prerequisites

Before you start, you will need the following information from MySQL.
  • Host (Endpoint without the port or database name)
  • Port (The port used to connect to your database)
  • User (The username of the service account)
  • Password (The password for the service account user)
  • SSL, if active (Toggle “Connect Through TLS” switch)

​
Connecting MySQL to Upsolve

  1. Navigate to your project in Upsolve and open Project settings → Connections.
  2. Select your data source from the Connect data cards to begin.
  3. The MySQL connection form opens with MySQL preselected.
  4. Fill out the data source details form as shown in the image below, including:
    • Host (Endpoint without the port or database name)
    • Port (The port used to connect to your database)
    • User (The username of the service account)
    • Password (The password for the service account user)
    • Connect Through TLS (Toggle switch if SSL is active)
  5. Click “Test & Create Connection” to establish the data source.
Congratulations! You’ve successfully created a new data source between MySQL and Upsolve. You can now access and manage your MySQL data seamlessly within the Upsolve platform.