Tool recommendations for connecting to MemSQL


#1

(Ported from memsql-public-chat Slack channel)

Amir [12:26 PM]
Hi guys,
What is the best tool you recommend for connecting to MemSQL 6.0. I tried MySQL Workbench 8.0 and I receive a handshake error. MySQL Workbench 6.3 connects, however, I have some other incompatibility issues with it when working in Amazon workspace.

jack [12:33 PM]
@Amir mysql changed the default authentication protocol in MySQL 8, so to connect to memsql with the MySQL 8 connector you will need to set the client configuration default-auth=mysql_native_password in some fashion, or you can use any version older than 8.

The same issue exists using the MySQL 8 C connector and connecting to an older version of MySQL (see https://bugs.mysql.com/bug.php?id=90994).

From https://stackoverflow.com/questions/51737964/error-connecting-to-memsql-with-mysql-c-connector

John Toups [3:17 PM]
@Amir I use Querious (mac mysql client) and Navicat (is mac/win) with no issues, except that the table-sync tools don’t work. everything else is peachy.


#2

After continuous problems with MySQL workbench, tools, etc. I decided to just use a good tool that just uses JDBC for connectivity. I tried a couple and ended up using DBeaver. Eclipse based and pretty stable.


#3

What problems did you run in to with MySQL workbench?


#4

it used to crash quite often on my mac. plus since it didnt use jdbc, i wasnt sure the behavior would be the same as sql executed in my code or scripts.


#5

On Windows we are using Toad, on Mac we are using Sequel Pro.
And to test performance, we are using either the MemSQL Studio or the CLI.
Hope this helps