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.

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"
  };

You can use this established connection to query your table as follows:

SELECT *
FROM mysql_datasource.example_table;