Now that we have identified our data source, let’s talk a bit about how we’ll interact with SingleStore.
Recommended: SingleStore Portal and Studio
When you signed up in Portal, you got access to our SQL Editor and Visual Explain tools, as well as to SingleStore Studio via a link within your cluster details. Portal and Studio are the best places to interact with your SingleStore data, build new data pipelines, and test out queries. Click here to get a tour of Studio and make sure you explore the features in Portal, as well as the Tutorials available through the Help button.
If you do not plan to use SingleStore Studio, make sure that you have the appropriate client drivers prior to using other database administration tools.
If you’re coming from MariaDB or MySQL, you may already be comfortable with Workbench. You can download MySQL Workbench here.
Note: When defining your connection, you will need to go to the Advanced tab and insert
defaultAuth=mysql_native_password in the “Others:” field to ensure proper authentication.
MySQL Command Line
Within your SingleStore Portal, your cluster details will include a MySQL Command section. This gives you an easy way to use the command line to connect to SingleStore. You can find the download for the MySQL shell here.
Note: When defining your connection, you will need to enter this at the MySQL command line:
--defaultAuth=mysql_native_password to ensure proper authentication.