Document Center

    AnalyticDB for MySQL

    • Notifications
      • [Notice] Free extension of backup set retention period ended
      • [Notice] Announcement of free extension of backup set retention period
      • Announcements
    • Release notes
    • Product Introduction
      • What is AnalyticDB for MySQL?
      • Editions
      • Features
      • Benefits
      • Scenarios
      • Customer Case
        • Transportation and logistics
          • Intelligent urban public transportation system built based on AnalyticDB for MySQL
        • Internet
          • Keruyun precision marketing solution
          • Fine-grained advertisement management solution for Irobotbox
          • Real-time BI analytics for the Internet industry
        • New retail
          • AnalyticDB for MySQL empowers Flowerplus business development
        • Finance
          • Aggregate payment solution
      • Limits
      • Terms
    • Pricing
      • Billing methods and prices
      • Billing details about specifications changes
      • Impact of expiration and overdue payments
      • Renewal
    • Getting Started
      • Use AnalyticDB for MySQL
      • Create an Alibaba Cloud account
      • Create a cluster
      • Create a database account
      • Configure a whitelist
      • Connect to an AnalyticDB for MySQL cluster
      • Create a database
      • Import and query data
    • User's Guide
      • Instructions for new AnalyticDB for MySQL users
      • Database Connection
        • Apply for or release a public endpoint
        • Tool compatibility
          • Compatibility overview
          • Navicat Premium
          • DBeaver
          • DBVisualizer
          • SQL WorkBench/J
          • DataGrip
          • Oracle Golden Gate
          • Tableau
          • QlikView
          • Yonghong BI
          • FineBI 5.0
          • FineReport 10.0
          • Scriptella
          • Smartbi
        • Use the MySQL command-line tool to connect to AnalyticDB for MySQL
        • Use a business system to connect to AnalyticDB for MySQL
          • Java
          • Druid connection pool
          • Python
          • PHP
          • C# for macOS
          • Go
        • Use a client to connect to AnalyticDB for MySQL
          • DBeaver
          • Navicat
          • SQL WorkBench/J
          • DBVisualizer
        • Enable PrepareStatement for a client in different programming languages
      • Separation of hot and cold data storage
      • Data Warehouse Development
        • Use DataWorks to schedule AnalyticDB for MySQL tasks
        • Use Kettle to synchronize local data to AnalyticDB for MySQL
      • End-to-end data management
        • Log on to a database
        • Manage data assets
        • Develop and schedule tasks
      • Data Visualization
        • FineBI
        • Quick BI
        • Yonghong BI
        • DataV
        • Tableau
        • QlikView
        • FineReport
        • Power BI
        • Smartbi
      • Cluster Management
        • Set a maintenance window
        • Resource pool overview
        • Manage resource pools
        • EIUs
        • Scale out resources
        • Query execution modes
        • Modify the configurations of an AnalyticDB for MySQL cluster
        • Delete a cluster
        • Manage O&M events
      • Materialized views
        • Overview
        • Create materialized views
        • Refresh materialized views
        • Manage materialized views
        • Query materialized views
        • Customer stories
          • Success story I
          • Success story II
          • Success story III
      • Data Security
        • Configure a whitelist
        • Configure SQL audit
        • Disk encryption
      • Account And Permission Management
        • Account types
        • Permission model
        • Database accounts and permissions
        • RAM users and permissions
        • Authorize the service account
        • Reset the password of a privileged account
      • Backup And Recovery
        • Manage backups
        • Clone a cluster
      • Monitoring And Alerts
        • View monitoring information
        • Set an alert rule
      • Tag management
        • Unbind a tag
        • Filter clusters by tag
        • Bind a tag
      • Diagnostics and optimization
        • Data modeling optimization
      • Daily health reports
    • Developer‘s Guide
      • Welcome
        • Instructions for database developers
        • Prerequisites
      • Data import and export
        • Supported data sources
        • Data base
          • Use DTS to Import Data
            • Synchronize data from an ApsaraDB RDS for MySQL instance to an AnalyticDB for MySQL cluster
            • Synchronize data from aDRDS database to an AnalyticDB for MySQL cluster
            • Migrate data from a PolarDB for MySQL cluster to an AnalyticDB for MySQL V3.0 cluster
          • Use external tables to import data
            • Use external tables to import data from ApsaraDB RDS for MySQL to AnalyticDB for MySQL
            • Use external tables to import data from a self-managed MySQL database to AnalyticDB for MySQL
          • Use external tables to export data
            • Use external tables to export data from AnalyticDB for MySQL to ApsaraDB RDS for MySQL
            • Use external tables to export data from AnalyticDB for MySQL to a self-managed MySQL database
          • Use DataWorks to synchronize data from ApsaraDB RDS for MySQL
            • Overview
            • Configure an ApsaraDB RDS for MySQL connection
            • Configure an Oracle connection
            • Configure an SQL Server connection
            • Configure an AnalyticDB for MySQL V3.0 data source
            • Configure the source and destination connections for a synchronization task
        • OSS
          • Use DataWorks to import data from OSS
            • Configure an OSS connection
            • Configure an AnalyticDB for MySQL connection
            • Configure the source connection and destination connection for a synchronization task
          • Import OSS data to AnalyticDB for MySQL by using external tables
          • Export data to OSS by using external tables
        • HDFS
          • Use external tables to import data from Apsara File Storage for HDFS to AnalyticDB for MySQL
          • Use external tables to export data from AnalyticDB for MySQL to Apsara File Storage for HDFS
        • Big data
          • Use DataWorks to import data from EMR
            • Configure an HDFS connection
            • Configure a MaxCompute connection
            • Configure an AnalyticDB for MySQL connection
            • Configure the source and destination connections for a synchronization task
          • Use DLA to import data from Apache Hadoop
            • Feature description
            • Procedure
          • Import MaxCompute data to AnalyticDB for MySQL
          • Use external tables to export data to MaxCompute partitioned tables
          • Use Apache Flink to write data to AnalyticDB for MySQL
        • Apache Kafka
          • Overview
          • Use Logstash to write Apache Kafka data to AnalyticDB for MySQL
        • Log data
          • Use Logstash to collect log data in real time
          • Use Log Service to transfer log data to AnalyticDB for MySQL
        • Local data
          • Use the LOAD DATA statement to import local data
          • Use the AnalyticDB for MySQL import tool to import on-premises data
        • Asynchronously submit an import or export task
      • SQL manual
        • Basic data types
        • Complex Data Types
          • Array
          • Map
          • JSON
        • Reserved words
        • SQL offset table
          • DDL differences
          • DML differences
          • Differences in other SQL features
          • Unsupported data types and operators
        • Data definition statements
          • CREATE DATABASE
          • CREATE TABLE
          • CREATE RESOURCE GROUP
          • CTAS
          • ALTER TABLE
          • CREATE VIEW
          • DROP DATABASE
          • DROP TABLE
          • DROP VIEW
          • TRUNCATE TABLE
          • SHOW
        • Data manipulation statements
          • INSERT INTO
          • REPLACE INTO
          • ALTER RESOURCE GROUP
          • DROP RESOURCE GROUP
          • INSERT SELECT FROM
          • REPLACE SELECT FROM
          • INSERT OVERWRITE INTO SELECT
          • INSERT ON DUPLICATE KEY UPDATE
          • UPDATE
          • DELETE
          • KILL PROCESS
          • SHOW PROCESSLIST
        • Data query language
          • SELECT
            • Syntax
            • LIMIT
            • UNION, INTERSECT, and EXCEPT
            • WITH
            • GROUP BY
            • HAVING
            • JOIN
            • ORDER BY
            • Subqueries
          • Query users
          • CROSS JOIN
        • Data control language
          • CREATE USER
          • DROP USER
          • GRANT
          • RENAME USER
          • REVOKE
        • Data dictionary of the metadatabase
      • System Functions
        • Control flow functions
        • Numeric functions and operators
          • Arithmetic operators
          • Numeric functions
        • Date and time functions
        • String functions
        • Bit functions and operators
        • Geometry functions
          • Operation functions
          • Spatial relation functions
          • Accessor functions
          • Spatial constructor functions
        • JSON functions
        • Window functions
        • Aggregate functions
        • Encryption and compression functions
        • CAST functions
      • Full-text Search
        • Create a full-text index
        • Query data by using full-text indexes
        • Custom analyzers and dictionaries
      • Query throttling configurations
      • API Reference
        • List of operations by function
        • Request structure
        • Request signatures
        • Common parameters
        • RAM authorization
        • Manage the service-linked role
        • Manage the service-linked role for disk encryption
        • Cluster management
          • CreateDBCluster
          • DescribeDBClusters
          • ModifyDBCluster
          • DeleteDBCluster
          • DescribeDBClusterAttribute
          • ModifyDBClusterMaintainTime
          • DescribeAutoRenewAttribute
          • ModifyAutoRenewAttribute
          • ModifyDBClusterDescription
          • DescribeAvailableResource
          • ModifyDBClusterResourceGroup
        • Manage Resource Pools
          • CreateDBResourcePool
          • DeleteDBResourcePool
          • DescribeDBResourcePool
          • ModifyDBResourcePool
          • BindDBResourcePoolWithUser
          • UnbindDBResourcePoolWithUser
        • Elastic Plan Management
          • CreateElasticPlan
          • DeleteElasticPlan
          • DescribeElasticDailyPlan
          • DescribeElasticPlan
          • ModifyElasticPlan
        • Database
          • DescribeTables
          • DescribeAllDataSource
          • DescribeSchemas
          • DescribeTableDetail
          • DescribeProcessList
          • DescribeColumns
          • DescribeTaskInfo
          • DescribeSQLPlan
          • DescribeSQLPlanTask
          • KillProcess
          • DescribeTablePartitionDiagnose
          • DescribeLoadTasksRecords
          • DescribeConnectionCountRecords
        • Log management
          • DescribeSlowLogRecords
          • DescribeSlowLogTrend
          • DescribeAuditLogConfig
          • ModifyAuditLogConfig
          • DescribeAuditLogRecords
        • Region management
          • DescribeRegions
        • Network management
          • AllocateClusterPublicConnection
          • DescribeDBClusterNetInfo
          • ReleaseClusterPublicConnection
          • ModifyClusterConnectionString
        • Account management
          • CreateAccount
          • DeleteAccount
          • DescribeAccounts
          • DescribeOperatorPermission
          • GrantOperatorPermission
          • ResetAccountPassword
          • RevokeOperatorPermission
          • ModifyAccountDescription
          • DescribeAllAccounts
        • Tag management
          • TagResources
          • ListTagResources
          • UntagResources
        • Backup and restoration
          • DescribeBackups
          • DescribeBackupPolicy
          • ModifyBackupPolicy
          • ModifyLogBackupPolicy
        • Security management
          • DescribeDBClusterAccessWhiteList
          • ModifyDBClusterAccessWhiteList
        • Monitoring management
          • DescribeDBClusterPerformance
          • DescribeDBClusterResourcePoolPerformance
          • DescribeInclinedTables
          • DescribeTableStatistics
        • O&M events
          • DescribeMaintenanceAction
          • ModifyMaintenanceAction
        • SQL diagnostics
          • DescribeDiagnosisRecords
          • DescribeDiagnosisDimensions
          • DescribeDownloadRecords
          • DownloadDiagnosisRecords
        • Cluster running reports
          • DescribeTableAccessCount
          • DescribeSqlPattern
          • DescribeDBClusterHealthReport
          • DescribeDBClusterForecast
        • Appendixes
          • Cluster states
      • SDK Reference
        • SDK reference
    • Performance Optimization
      • Analysis query
        • Overview
        • Query process and execution plan
        • Operators
        • Factors that affect query performance
        • Typical slow queries
        • Query performance analysis
          • Analyze execution plans by using SQL diagnostics
            • Introduction to SQL diagnostics
            • Use query monitoring charts and lists
            • Use execution plans to analyze queries
          • Use the EXPLAIN and EXPLAIN ANALYZE commands to analyze execution plans
          • Use a slow query table
      • Tuning queries
        • Overview
        • SQL self-diagnostics
          • View query properties and diagnosis results
          • Query-level diagnosis results
          • Stage-level diagnostic results
          • Operator-level diagnosis results
        • Join tuning
          • Rewrite left join to right join
          • STRAIGHT_JOIN
          • Manually adjust join orders
        • Filter conditions without pushdown
        • Grouping and aggregation query optimization
      • Common issues and improvement measures
    • Best Practices
      • Schema design
      • Rules for SQL development
      • Optimization of data changes
      • Query optimizers
        • Persist plan and Query-Blocker
      • Permission management by using views
    • Performance White Paper
      • Overview
      • Test description based on standard dataset
        • Test environments
        • Test procedure
        • Test method
      • Test description based on application scenarios
        • Query scenarios
        • Data import scenarios
      • Appendix: test procedure
        • TPC-H test
          • Preparations
          • AnalyticDB for MySQL
          • Presto
          • Construct data
          • Import data
          • TPC-H dataset
        • TPC-DS test
          • Preparations
          • Install TPC-DS tools
          • Construct data
          • Create test tables in AnalyticDB for MySQL
          • Import test data
          • TPC-DS dataset
    • Technical Whitepaper
      • Industry trends and background
        • Technology development trends
        • Business challenges
      • Technical architecture
        • Overall architecture
        • Elastic computing layer
        • Serverless storage layer
      • Technical benefits
        • High performance
          • Xuanwu analytical storage engine
          • Xihe analytical computing engine
          • Cost-based SQL optimization
          • Query optimization based on hybrid loads
          • Read/write splitting architecture
        • High availability
          • High availability of the access layer
          • High availability of the computing layer
          • High availability of the storage layer
        • High scalability
          • Elasticity of the computing layer
          • Elasticity of the storage layer
      • Backup and restoration
        • How backup works
        • How restoration works
      • Monitoring and alarm
        • Monitoring mechanism
          • Data collection
          • Data storage
          • Data aggregation analysis
        • Alerting mechanism
        • Obtain monitoring data (API operation)
    • FAQ
 
All Products
Search
  • Document Center
  • AnalyticDB for MySQL
  • Developer‘s Guide
  • Data import and export
  • OSS
  • Use DataWorks to import data from OSS
  • Configure an AnalyticDB for MySQL connection

This Product

  • This Product
  • All Products

    Configure an AnalyticDB for MySQL connection

    Document Center

    Configure an AnalyticDB for MySQL connection

    Last Updated: Aug 03, 2020

    To configure an AnalyticDB for MySQL connection, you can follow the steps for using DataWorks.

    For more information, see Configure the AnalyticDB for MySQL connection .

    How helpful was this page?

    What might be the problems?

      More suggestions?

      Thank you! We've received your feedback.