Add phpMyAdmin to Local


#1

I’ve just installed Local and spent a short while getting to know it. It’s running really well but I am surprised not to see phpMyAdmin included. Can I make a request for it?


#2

We include Adminer and a one-click connection to Sequel Pro.

I recommend Sequel Pro if you’re wanting something more robust than Adminer. There’s a one-click connect button inside the Database tab :slight_smile:


#3

Thanks Clay.

Yep, I have Sequel Pro and had a look at Adminer but I’ve been using phpMyAdmin for soooooo long it would be good to have that option. As it’s free, can’t it be added as an option?


#4

Hi again

I’m guessing that Adminer is installed in each site so if I’m working on 10 sites, I’d have 10 copies of Adminer. Is that right? In which case I’m guessing this is why you’ve not included phpMyAdmin.

Can it be made possible to have a single installation of phpMyAdmin somewhere like ‘Local Sites’ folder and have a one-click link to it show the databases for the site being worked on?

Cheers

Jon


#5

One thing you can do is create a site that runs PHPMyAdmin and then connect to the databases in the other sites.

I haven’t tested this and I’m just typing this out my thoughts, but you can maybe use the domain of the site you’re trying to connect to as the host and then when you enter the port it will most likely be 3306. Then, just use the details provided in the Database tab for anything else that needs filled in.

I know it’s a familiarity thing, but Sequel Pro is super easy to learn and I think you’ll ultimately be happier with Sequel Pro :slight_smile:


#6

Hi, @clay! Since Sequel Pro is Mac only, do you know any alternatives for Windows users? I really like PHPMyAdmin too, but if it is not possible, it would be good to have at least an usable solution for Windows too.

Thanks!


#7

You can still use Adminer which can do everything PHPMyAdmin does. Is there a particular pain point you’re having with Adminer?

Here are some good MySQL clients for Windows:


#8

Here’s how I do it:

  • Install the Volumes Manager addon (https://github.com/getflywheel/local-addon-volumes)
  • Install phpMyAdmin. Pretty much anywhere, I use ~/Local Sites/phpmyadmin
  • For each site, map this path (source) to a public container destination (More > Volumes), I use /app/public/phpmyadmin

#9

I too, would like to see phpmyadmin available for local by flywheel sites I have running. This app is supposed to help streamline development in a user-friendly way it would seem. Everything about this app is perfect except for the unfamiliar default “Adminer” web-based way of managing the database. I have used phpmyadmin for years, and it has a user interface and user-friendly environment that I am used to using. Using the “Adminer” makes me feel sort of out-of-place here.

Please reconsider having phpmyadmin capabilities easily from within the Local by Flywheel app in the future. And having to set this up so that I connect to the phpmyadmin database on my localhost machine (separate from what this app provides), somewhat contradicts what this app claims to do, which is to “…simplify the workflow of WordPress developers and designers”.

Thank You!


#10

Hi,

Could you kindly list down the step by step method please? It would be absolutely useful for the newbies like mw :blush:

Thanks,
Praba.


#11

PHPMyAdmin is an overkill for local environments, all needed stuff can be done on Adminer, which is just one file :slight_smile: . If you really need a good SQL manager, I really like and recommend trying DataGrip by jetBrains. I just add a new mysql connection when I create a new site on local, and it works perfectly, with saving all queries, robust tools to filter database and more :slight_smile: