This topic describes a compatibility test between DataGrip and AnalyticDB for MySQL, and provides screenshots of test results. Compatibility is tested from a variety of aspects including connectivity, database listing, and table creation.

Test environment

MySQL JDBC driver DataGrip
mysql-connector-java-8.0.15 Download DataGrip.

Test scope

  • Test connectivitytest
  • List databasesdatabase
    To display all schemas, select All schemas in the connection configuration. All
  • Create a tabletable
  • List all tablesall tables
  • View the schema of a tableview
  • Write data to a tableinsert
  • Query the data of a table1
  • Create a viewview
  • Query a view2