MySQL is an open-source relational database management system (RDBMS).
Parameter | Required | Description |
---|---|---|
Name | Yes | A unique identifier for your MySQL source |
Host | Yes | The hostname or IP address of your MySQL server |
Port | Yes | The port number on which MySQL is running (default: 3306) |
Database Name | Yes | The name of the database you want to connect to |
Schema Name | No | Optional schema name (if different from database name) |
User | Yes | Username with appropriate permissions to access the database |
Password | Yes | Password for the specified user |
SELECT
- For reading data from tablesSHOW DATABASES
- For listing available databasesSHOW VIEW
- For accessing viewsREFERENCES
- For foreign key constraints