跳转至

MySQL

What is MySQL ?

MySQL is one of the most recognizable technologies in the modern big data ecosystem. Often called the most popular database and currently enjoying widespread, effective use regardless of industry, it’s clear that anyone involved with enterprise data or general IT should at least aim for a basic familiarity of MySQL.

Environment

Note

If you need to use this data source, you need to upgrade the DataCap service to >= 1.0.x

Support Time: 2022-09-19

Configure


DataCap uses configuration files by default mysql.json

Note

If your MySQL service version requires other special configurations, please refer to modifying the configuration file and restarting the DataCap service.

Field Required Default Value
Name :material-check-circle: -
Host :material-check-circle: 127.0.0.1
Port :material-check-circle: 3306
Field Required Default Value
Username :material-check-circle: -
Password :material-check-circle: -
SSL :material-close-circle: false
Field Required Default Value
Database :material-check-circle: default

Note

You can add the already supported MySQL parameters by adding Key Value, the parameters can be reference document

Default:

Key value
useOldAliasMetadataBehavior true

Version (Validation)


Warning

The online service has not been tested yet, if you have detailed test results, please submit issues to us

  • 5.x
  • 6.x
  • 7.x

最后更新: December 7, 2023
创建日期: January 29, 2023

评论