Add a MySQL-compatible database data source

更新时间:
复制 MD 格式

Add a MySQL-compatible database data source in DataV-Board to use older MySQL database versions as widget data sources.

Prerequisites

You have a MySQL-compatible database data source ready to add.

Procedure

  1. Log on to the DataV console.

  2. On the My Data tab, select Data Source Management and click Add Data.

  3. From the Type list, select MySQL-Compatible Database.

  4. Enter the database information.

    Parameter

    Description

    Name

    Display name for this data source.

    Domain Name

    Domain name or IP address of the database server.

    Important

    The address must be accessible from the DataV server over the internet or the internal network of some Alibaba Cloud regions.

    Username

    Username for the database.

    Password

    Password for the database.

    Port

    Port number of the database.

    Database

    Name of the target database.

    insecureAuth

    Enables compatibility with MySQL versions earlier than 5.2. Full compatibility is not guaranteed.

    Compatible with Azure Database for MySQL

    Enables compatibility with MySQL databases when turned on.

    The system automatically tests the connection after you enter the database information.

  5. If the connection is successful, click OK to add the data source.