Access to MariaDB SkySQL services is
restricted on a per-service basis.
Add the following IP addresses to allow MindsDB to connect to your MariaDB
service, do this by clicking on the cog icon and navigating to Security Access.
In the dialog, input as prompted – one by one – the following IPs:
A
certificate authority chain
(.pem file) must be provided for proper TLS certificate validation.From your selected service, click on the world globe icon (Connect to service).
In the Login Credentials section, click Download. The aws_skysql_chain.pem
file will download onto your machine.
To print the query template, select Add Data in either the top or side
navigation and choose MariaDB SkySQL from the list. Fill in the values and run
a query to complete the setup.Here are the codes:
Copy
Ask AI
CREATE DATABASE maria_datasource --- display name for the databaseWITH ENGINE = 'MariaDB', --- name of the MindsDB handlerPARAMETERS = { "host": " ", --- host IP address or URL "port": , --- port used to make TCP/IP connection "database": " ", --- database name "user": " ", --- database user "password": " ", --- database password "ssl": True/False, --- optional, the `ssl` parameter value indicates whether SSL is enabled (`True`) or disabled (`False`) "ssl_ca": { --- optional, SSL Certificate Authority "path": " " --- either "path" or "url" }, "ssl_cert": { --- optional, SSL certificates "url": " " --- either "path" or "url" }, "ssl_key": { --- optional, SSL keys "path": " " --- either "path" or "url" }};
MindsDB ProTo connect to the MindsDB Pro account, use the details below:
Now that you are all set, we recommend you check out our Tutorials and
Community Tutorials sections, where you’ll find various examples of
regression, classification, and time series predictions with MindsDB.To learn more about MindsDB itself, follow the guide on
MindsDB database structure. Also, don’t miss out on the
remaining pages from the SQL API section, as they explain a common SQL
syntax with examples.Have fun!