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
Log on to the DataV console.
On the My Data tab, select Data Source Management and click Add Data.
-
From the Type list, select MySQL-Compatible Database.
-
Enter the database information.
Parameter
Description
Name
Display name for this data source.
Domain Name
Domain name or IP address of the database server.
ImportantThe 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.
-
If the connection is successful, click OK to add the data source.