phpMyAdmin/Adminer didn't show up

Support
1

Hi,

I’m using Local Lightning Public Beta. Before this Local have button for me to access to the database by using Adminer, but now I can’t. How can I access my database by using phpmyadmin or adminer with latest version of Local?

2

Hi @mtcore,

Good catch! Adminer isn’t in the public beta quite yet but it’s on our list of things to add. See “What’s Next” here: Local Lightning Public Beta

In the meantime, you can connect to the database with other clients such as Sequel Pro (macOS) or HeidiSQL (Windows).

To connect to a Local Lightning site’s database, copy the details from the site’s “Database” tab in Local and then enter it into Sequel Pro or HeidiSQL. On macOS, you’ll want to connect using the socket. On Windows, connect using the IP and port.

3

Hi @clay

Thanks for your replied. Currently, I’m using MySQL Workbench. Can I use it to access the database?

4

Yup! Here’s how:

  1. Open MySQL Workbench and add a new connection that matches the settings in the site’s “Database” tab. Note: you can use either localhost or 127.0.0.1 for the Hostname.

33%20AM
33%20AM3622×1834 762 KB

  1. Success!

37%20AM
37%20AM2390×1770 348 KB

5

Clicking the SEQUEL PRO button doesn’t work for me in Lightening beta 5.0.5+900. I’ve also tried just entering the info manually and get the same result.

36%20PM
36%20PM2014×1390 234 KB

6

Hey @mrtorbert, check this out >

7

Hey Matt. Thanks for the response.
I installed 97c1b85783 but I’m getting the same error.

8

Alright, I poked around a bit in my copy of Local and was able to recreate that error by trying to open SequelPro for a site that isn’t “running” yet:

28%20PM
28%20PM2966×1582 395 KB

Have you hit START SITE in the top right corner of the Local site dashboard?

9

Well that’s a bit embarrassing on my part if that’s the case. :slight_smile:
I can’t confirm whether it was stopped at the time, but it’s started now, though it’s stuck on "Connecting…"

41%20PM
41%20PM4071×1581 367 KB

10

Hmm… That is what the old version of Sequel Pro would do (just hang on connecting). Just to be sure, would you make sure that you don’t have an old copy of SP lingering around in another folder on your computer and when you go to the “About Sequel Pro” in the drop down menu it shows the correct build:

29%20PM
29%20PM994×602 146 KB

11

Ugh. I must be losing it.
I’ve redownloaded it and it’s working now.

Thanks for all your help and patience. :slight_smile:

13

Hey Everyone,

Wanted to pass along that you can also use TablePress instead of Sequel Pro.

14

Hey there! Adminer has returned in Local 5.0.6 (Beta)