MySQL system¶

The MySQL system represents a MySQL database available over the network: See the supported column types list for a overview of which MySQL column types are supported and how they are mapped to Sesam types.

Prototype¶

{
    "_id": "sql_system_id",
    "type": "system:mysql",
    "name": "The MySQL Database",
    "username":"$ENV(username-variable)",
    "password":"$SECRET(password-variable)",
    "host":"fqdn-or-ip-address-here",
    "port": 3306,
    "database": "database-name"
}

Properties¶

Property	Type	Description	Default	Req
`username`	String	Username to use when connecting to the database.		Yes
`password`	String	Password to use when connecting to the database.		Yes
`host`	String	Host name or IP address to the database server. Must be DNS resolvable if non-numeric.		Yes
`port`	Integer	Database IP port.	3306
`database`	String	Name/id of database to connect to.		Yes

Example configuration¶

Example MySQL configuration:

{
    "_id": "sqlserver_db",
    "name": "MySQL test database",
    "type": "system:mysql",
    "username": "$ENV(username-variable)",
    "password": "$SECRET(password-variable)",
    "host": "localhost",
    "port": 3306,
    "database": "testdb"
}

Microsoft SQL Server system

Oracle system