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?

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…

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

Yup! Here’s how: 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] Success! [37%20AM]

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]

Hey @mrtorbert , check this out > [image] Unable to connect to site with Sequel Pro with Mac Lighting Support MySQL 8.0 needs the Sequel Pro nightly. https://sequelpro.com/test-builds

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

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] Have you hit START SITE in the top right corner of the Local site dashboard?

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]

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 buil…

Ugh. I must be losing it. I’ve redownloaded it and it’s working now. Thanks for all your help and patience. :slight_smile:

Hey Everyone, Wanted to pass along that you can also use TablePress instead of Sequel Pro. [image] How to Use TablePlus with Local Flywheel offers expert WordPress support at no charge. We also have a lot of answers to common questions. Dive into our help section for easy answers. …

phpMyAdmin/Adminer didn't show up

Support

mattwhosthat September 18, 2019, 7:32pm 6

Hey @mrtorbert, check this out >

Topic		Replies	Views
I can't find "connect to adminer" Support	3	1366	October 3, 2019
No Adminer button Feature requests	5	1271	October 3, 2019
Adminer works but not open sequel pro Support	1	564	December 5, 2019
Adminer not working--neither is Sequel Pro! Support	0	392	April 14, 2020
Sequel Pro vs. Adminer Support	2	1624	May 4, 2017

phpMyAdmin/Adminer didn't show up

Related topics