Log on to the Data Lake Analytics console.
In the left-side navigation pane, click Endpoint. In the endpoint list, locate the row that contains the target endpoint and click Log on in DMS in the Actions column. Run the following statement to create a MySQL schema in DLA:
CREATE SCHEMA hello_mysql_vpc_rds WITH DBPROPERTIES (
CATALOG = 'mysql',
LOCATION = 'jdbc:mysql://rm-2zer0vg58mfofake.mysql.rds.aliyuncs.com:3306/rds_mysql_dbname',
USER = 'rds_mysqldb_username',
PASSWORD = 'rds_mysqldb_password',
INSTANCE_ID = 'rds_mysql_instance_id',
VPC_ID = 'rds_mysqldb_vpcid'
VPC_ID: indicates the ID of the VPC where your MySQL instance is located, as shown in the following figure.
INSTANCE_ID: indicates the ID of your MySQL instance. You can view the instance ID on the Instance Details page.
How helpful was this page?
What might be the problems?