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