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.

• Connecting using URL
• Connecting using paramaters

Connect MySQL to MindsDB by providing the URL parameter. Learn more here.

Connect MySQL to MindsDB by providing the URL parameter. Learn more here.

Connect MySQL to MindsDB by providing the following parameters:

• 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. Default: 3306.
• database is the database name.

There are several optional parameters that can be used as well.

• ssl is the ssl 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.

If you installed MindsDB locally via pip, you need to install all handler dependencies manually. To do so, go to the handler’s folder (mindsdb/integrations/handlers/mysql_handler) and run this command: pip install -r requirements.txt.

Usage

In order to make use of this handler and connect to the MySQL database in MindsDB, the following syntax can be used:

• Connecting using URL
• Connecting using paramaters

CREATE DATABASE mysql_datasource
WITH
  ENGINE = 'mysql',
  PARAMETERS = {
    "url": "mysql://user@127.0.0.1:3306"
  };

CREATE DATABASE mysql_datasource
WITH
  ENGINE = 'mysql',
  PARAMETERS = {
    "url": "mysql://user@127.0.0.1:3306"
  };

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;