Local Help Docs Advanced

How to Use TablePlus with Local

For database access to your Local sites with Local version 5 and later, we recommend using TablePlus, an easy-to-use database manager for Windows and Mac.

note

Local Lightning currently does not include Adminer for database access. Adminer will return in a future release. In the meantime, give TablePlus a try!

NOTE

Local Lightning currently does not include Adminer for database access. Adminer will return in a future release. In the meantime, give TablePlus a try!

1

Install TablePlus

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.

warning

Make sure you have started the site in Local in order for TablePlus to properly connect. Keep Local running while you’re using TablePlus.

3

Create a New Connection

Choose “Create a new connection…” then pick MySQL and click Create.

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!

note

Looking for additional reading? TablePlus has a lot of great resources on this page.