TablePlus on Local
There are many tools available that you can use to connect to your Local site databases. One available tool is TablePlus, an easy-to-use database manager for Windows and Mac.
Table of Contents:
note
If you are already a TablePlus user, you can make use of the TablePlus Add-on to quickly access the Local site’s database within TablePlus.
If you have any questions about the add-on itself, please see the dedicated category in the forums.
Step 1: Download and Install TablePlus
Step 2: Find Local Database Information
We’ll need to copy several lines of information from Local into TablePlus. Open the site you want to connect to and click on the Database tab.
note
Make sure you have started the site in Local in order for TablePlus to properly connect. Keep Local running while you’re using TablePlus.
Step 3: Create a New Connection
Choose “Create a new connection…” then pick MySQL and click Create.
Step 4: Copy Local Database Details
Copy the host, socket, database name, username, and password into the MySQL Connection window.
Check “Use socket” before copying the socket details.
After copying your site details from Local, click “Test”. You should see several green fields if the connection was established successfully. If so, click “Connect” and start editing!
If you need more information TablePlus has a lot of great resources on this page.