(Ported from memsql-public-chat Slack channel)
Amir [12:26 PM]
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).
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.