Skip to main content

MySQL

Connect to MySQL.

Configuration

The following values are needed to connect to MySQL:

  • Address: URL / hostname:port of the instance
  • Database: database name to pull tables from
  • Username: user to authenticate as
  • Password: password used to authenticate

If your database requires SSL, you may also upload the SSL Root Cert file.

Datasets

By default, each table in the database will be automatically indexed as a dataset within Predibase.

Connection Query Template

CREATE CONNECTION mysql_connection
CONNECTION_TYPE = MYSQL
DATABASE_ADDRESS = '127.0.0.1:3306'
DATABASE_NAME = 'database'
USERNAME = 'username'
PASSWORD = 'password'