Databases
MySQL
Databases
MySQL
This is the implementation of the MySQL data handler for MindsDB.
MySQL is a fast, reliable, and scalable open-source database. It has been in development for more than 25 years and has been used in many production environments since.
Implementation
This handler is implemented using the mysql-connector-python
library. It’s a Python client for MySQL that doesn’t depend on any MySQL C libraries.
The required arguments to establish a connection are as follows:
user
is the database user.password
is the database password.host
is the host name, IP address, or URL.port
is the port used to make TCP/IP connection.database
is the database name.
There are several optional arguments that can be used as well.
ssl
is thessl
parameter value that indicates whether SSL is enabled (True
) or disabled (False
).ssl_ca
is the SSL Certificate Authority.ssl_cert
stores SSL certificates.ssl_key
stores SSL keys.
Usage
In order to make use of this handler and connect to the MySQL database in MindsDB, the following syntax can be used:
CREATE DATABASE mysql_datasource
WITH
ENGINE = 'mysql',
PARAMETERS = {
"host": "127.0.0.1",
"port": 3306,
"database": "mysql",
"user": "root",
"password": "password"
};
You can use this established connection to query your table as follows:
SELECT *
FROM mysql_datasource.example_table;