DBVisualizer connects to AnalyticDB for MySQL through the MySQL-compatible driver. This page covers the prerequisites and supported database operations.
Prerequisites
Before you begin, make sure you have:
DBVisualizer 10.0.24 (download)
Java 1.8 installed on your machine
An AnalyticDB for MySQL cluster — note the cluster endpoint, port, database name, username, and password
Supported operations
The following operations were tested against AnalyticDB for MySQL using DBVisualizer 10.0.24.
Test environment
| Component | Version |
|---|---|
| DBVisualizer | 10.0.24 |
| Java | java version "1.8.0_161" — Java HotSpot(TM) 64-Bit Server VM (build 25.161-b12, mixed mode) |
| MySQL client | mysql Ver5.6.46 for osx10.13 on x86_64 (Homebrew) |
Test results
Test connectivity
List databases
Create a table
List all tables
Query the schema of a table
Write data to a table
Query the data of a table
Create a view
Query the structure of a view
Query a view
What's next
Connect to AnalyticDB for MySQL — explore other supported clients and connection methods
SQL syntax reference — learn about AnalyticDB for MySQL-specific SQL syntax and features