Dolt comes with a built-in MySQL compatible server, making it easy to connect to your Dolt databases with existing SQL tooling. Here are a list of notable MySQL Editors and our compatibility status.
Notes and limitations
Recommended (see below)
Potential information schema and backup compatibility issues
Missing some information schema materials
dolt clone dolthub/ip-to-country && cd ip-to-country
dolt sql -q 'show tables'and you should see the following output
> dolt sql -q 'show tables'
| Table |
| IPv4ToCountry |
| IPv6ToCountry |
Dolt's sql server can be started with one command.
> dolt sql-server
Starting server with Config HP="0.0.0.0:3306"|U="root"|P=""|T="28800000"|R="false"|L="info"
The default configuration for our server uses a username of
rootand an empty password. You can configure access settings, logging, and timeouts by following additional documentation here.
Click on create a new connection:
Hit MySQL in the selection box and fill in the following information. All the parameters are the same as for any MySQL database.
When you hit
Testyou should see all the boxes turn green like in the above image. Finally, hit connect to access the Dolt server.
Let's start by selecting a database in the Dolt server and writing queries against it.
ip_to_countrydatabase. You should see tables populate to the left like below.
Now click on the table
IPv4ToCountryand see the screen populate. We just read from our Dolt database!
Finally, let's write a quick query on the dataset. Click the
SQLbutton in the top left and write the query in the box. Hit the
Run Currentbutton to execute it and the results should appear:
That's it! You've successfully connected Dolt to Tableplus and ran your first query.