Windows 10 odbc connection

our marketing team operates on windows 10. we would like to add an odbc connection into memsql. we are able to add various other databases but can’t seem to do it for memsql. always getting error.

we use the mysql odbc 8.0 ANSI and Unicode driver (8.00.16.00). but nothing works…

any advise?

We might be able to help if you can provide some more information about what errors you are seeing.

What version of MemSQL are you using? What errors does the MySQL connector show?

Hi.

Version of MEMSQL: MemSQL Community Edition (Single VM) version 5.0.6 on AWS

Error: "[MySQL][ODBC 8.0(a) Driver] Error in server handshake

Replicating error:

  1. on windows task bar search; open “odbc data source”.
  2. Click Add
  3. choose MySQL ODBC 8.0 ANSI Driver
  4. Enter any data source name/description
  5. for TCP/IP Server; enter AWS path name
  6. Enter User and password
  7. Confirm by “test”

I would highly advise you to upgrade to MemSQL 6.8, the latest version of the product.
It is available on the main website: https://www.memsql.com/free/

MemSQL 5.0 is no longer supported. You can find resources on how to upgrade here: https://docs.memsql.com/operational-manual/v5.8/upgrading-memsql/

The document below may be useful for you. When connecting to MemSQL, you have to pass --default-auth=mysql_native_password to the connector.

Thanks for the recommendations. We’ll definitely start upgrading.

Regarding the odbc, and passing the string. Can you tell me where do i have to add the string?

When i open the windows 10 odbc screen and select MySql 8.x driver, i have the following options:

Data Source Name: << i am guessing this is my own choice and i don’t pass here>>

Description: << i am guessing this is my own choice and i don’t pass here>>

TCP/IP Server: For AWS hosted databases, I just put the AWS connection address here and it works. do i append “–default-auth=MYMEMSQLPASSWORD” at the end here?

so if my aws string is “ec2-123.456.com”, does it become “ec2-123.456.com–default-auth=mysql_native_password” or does it become “ec2-123.456.com–default-auth=MYPASSWORD”

User: <>

Password: Is it here?

I tried a couple of combinations so i am probably not appending it right. Appreciate your help.

This option is used to pick an authentication mechanism. the value --default-auth=mysql_native_password specifies that the MySQL client that is connecting to the MemSQL server.

mysql_native_password is an authentication mechanism that MemSQL supports. You have to configure the client (the ODBC Connector) to use that authentication plugin. Passing the flag works if you use the command line mysql client.

thanks. is there a step of instructions with images I could follow to get the odbc connection set up? I am not sure where i have to pass the password, the flag etc. Or alternatively, can we set up a remote meeting for 10 mins? we are able to connect to all of other db’s (mysql, sql server, etc), but we seem to be having trouble with memsql.

thanks!

Hey , let me know if you are still facing the ODBC conenctivity issue with MemSQL

will do. We are upgrading to version 6.5 and check if we have the issue.