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'