Skip to content

Connecting to MySQL

Archived PuppyGraph 0.x documentation

This is the archived 0.x documentation. For new deployments, use puppygraph/puppygraph:latest (PuppyGraph 1.x) and the current docs. The 0.x schemas and UI described here don't apply to 1.x; see Migrating from v0.

Prerequisites

  • The MySQL instance is accessible over the network from the PuppyGraph instance.

Configuration

Configuration Explanation
Username The username of the database
Password The password of the database
JDBC URI A JDBC compatible connection URI of the data source. Read this page for more details on how to construct the URI.
JDBC Driver Class

The class name of the JDBC driver.

Please choose the name based on the version of the driver that is compatible with your MySQL database.

For example, if you use MySQL (Connector/J):

  • com.mysql.jdbc.Driver (MySQL v5.x and earlier)
  • com.mysql.cj.jdbc.Driver (MySQL v8.x and later)

Or if you use MariaDB Connector/J:

  • org.mariadb.jdbc.Driver
JDBC Driver URL

The URL of the MySQL-compatible JDBC Driver.

Please choose the version of the driver that is compatible with your MySQL database.

Demo

See Querying MySQL Data as a Graph for a complete demo for MySQL. The demo includes setting up the connection to a MySQL instance.