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'