MariaDB

Introduction
​MariaDB is an open source database that supports continuity and open collaboration. It is a community-developed, commercially supported fork of the MySQL relational database management system, intended to remain free and open-source software under the GNU General Public License.
Supported actions
For your MariaDB account, YAP ensures the following actions:
Create
Update row
New row
Search
Find row via custom query
Find row
Setup requirements
Before setup, please check that you have granted to YAP the permission to send notification to your MariaDB account. For this, sign in to MariaDB and authorize the permissions requested by YAP.
Connection 
The MariaDB connector allows querying in an external MariaDB database.
Field
Type
Description
Host
Required
The IP address or hostname (db.example.com) of where your database instance resides. Note, localhost and 127.0.0.1 are not valid!
Port
Required
Number field. Values will be converted into a number.
Database
Required
The name of the database you would like to interact with.
Username
Required
We recommend creating a new database user with extremely limited access.
Password
Required
Again, this should not be your production password. Make it strong! (We like using random.org.)
SSL Client Certificate
Optional
Required for SSL. Provide the contents of the client certificate file in PEM format. The certificate's Common Name (CN) must match the Host provided above. The certificate must be issued by a public CA and all CA certificates needed to establish the certificate's authenticity must be included. Self-signed certificates are not supported. For details see Python's documentation on Certificates.
SSL Private Key
Optional
Required for SSL, but it may also be part of the SSL Client Certificate as long as it comes first. Provide the contents of the private key file. The private key may not be encrypted.
For more details, please see Using MariaDB with Your Programs (API) and Database Resources.
Questions?
We're always happy to help with any issues you might have! 
Send us an email to [email protected] or request the demo with our sales team.

Last modified 3yr ago

Field	Type	Description
Host	Required	The IP address or hostname (db.example.com) of where your database instance resides. Note, `localhost` and `127.0.0.1` are not valid!
Port	Required	Number field. Values will be converted into a number.
Database	Required	The name of the database you would like to interact with.
Username	Required	We recommend creating a new database user with extremely limited access.
Password	Required	Again, this should not be your production password. Make it strong! (We like using random.org.)
SSL Client Certificate	Optional	Required for SSL. Provide the contents of the client certificate file in PEM format. The certificate's Common Name (CN) must match the Host provided above. The certificate must be issued by a public CA and all CA certificates needed to establish the certificate's authenticity must be included. Self-signed certificates are not supported. For details see Python's documentation on Certificates.
SSL Private Key	Optional	Required for SSL, but it may also be part of the SSL Client Certificate as long as it comes first. Provide the contents of the private key file. The private key may not be encrypted.