There are many tools available that you can use to connect to your Local site databases. One available tool is HeidiSQL, a graphical database manager for Windows.
Download HeidiSQL for Windows
We recommend downloading “Installer, 32/64 bit combined”.
We’ll need to copy several lines of information from Local into HeidiSQL. Open the site you want to connect to and click on the Database tab.
Take note of the following:
Tip: Typically, only the port will be different for each site. With this in mind, it can help speed up adding additional connections!
Make sure you have started the site in Local in order for HeidiSQL to properly connect. Keep Local running while you’re using HeidiSQL.
Click on “New” in the bottom left of HeidiSQL’s startup window.
Copy the host, port, database name, username, and password from Local’s Database tab (see Step 2) into the Settings tab.
After entering the details, you can rename the connection by right-clicking on “Unnamed” in the list to the left and clicking “Rename.”
Once you’re done entering the details and renaming if you wish, click on “Save” in the bottom left.
Finally, click on “Open” to initiate the connection.
Looking for additional reading? Check out HeidiSQL’s Help Document for more info.
It’s free and always will be.
Thanks! We'll contact you as soon as Local for Windows is available.
Next-level functionality and enhanced local development.
Sign up below and we’ll notify you the minute Local Pro is available for beta! Launching July 2019.
Thanks! We'll contact you as soon as the beta is available.
Local is only available as a desktop application, but no worries! Just enter your email in the box below and we'll send you a little reminder to download it via your desktop.
Thanks! Check your inbox for a link to download Local on your desktop.