MySQL#

The connection to MySQL is based on the mysql-connector-python library.

Dependency#

  • mysql-connector-python

Parameters#

Required:

  • 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.

Warning

Provide the parameters of an already running MySQL server. EvaDB only connects to an existing MySQL database.

Create Connection#

CREATE DATABASE mysql_data WITH ENGINE = 'mysql', PARAMETERS = {
     "user": "eva",
     "password": "password",
     "host": "localhost",
     "port": "5432",
     "database": "evadb"
};