Add phpMyAdmin to Local

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?

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:

2 Likes

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?

2 Likes

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

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:

1 Like

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!

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:

1 Like

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
5 Likes

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!

2 Likes

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.

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:

Been busily adding and deleting sites with Local by Flywheel for more than a week. I love it’s robust installation and nearly faultless operation. I have almost figured out it’s proprietary architecture on my computer and how to reconfigure that architecture to suit my development structure. That said, I am puzzled by the general disagreement with providing phpMyAdmin in the tool suite. It is the tool I use on my VPS platform and that all my sites and clients have and use on their sites. To learn and use another tool is simply maddening. I don’t need the sharpest needle in the haystack only the first one that is sharp enough to sew. For me that’s phpMyAdmin. I am approaching the point where I am going to commit to Local by Flywheel as my local development tool inasmuch as I have found workarounds for most of the idiosyncrasies I have encountered. I am grateful for the product and everyone that participates in this community.

1 Like

Since Adminer is not working (Problem with MySQL) there’s a need for another database tool.

Local’s competitor (the one with the elephant) includes phpMyAdmin. Many people are already familiar with it. And it does some things that Sequel Pro doesn’t do so easily, like whole database searches. It would be nice to see it in Local.

One way around this limitation is to install phpMyAdmin as a WordPress plugin. Someone has very nicely put phpMyAdmin into a plugin: https://wordpress.org/plugins/wp-phpmyadmin-extension/. Your mileage may vary, but it’s working in my development site.

1 Like

@clay, please stop stuffing Adminer (or Sequel Pro for that matter) down our throats, and just add phpmyadmin – it’s theee most used tool, period!

And try to imagine the fuzz in marketing when you can put this statement on your site: “Local now supports phpMyAdmin!”

2 Likes

This should be fairly easy to do as a plugin.

Maybe this can be a addon

Create new website with Local and replace PHPMyAdmin source code to the public folder.
Then, configure config.inc.php file to add other websites as the server selectbox of the phpmyadmin login screen.
Change the port number and verbose according to your requirements.

$i++;
$cfg['Servers'][$i]['verbose'] = 'Dev 1';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '10004';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['AllowNoPassword'] = false; 

Source: https://theinspired.dev/blog/how-to-add-phpmyadmin-to-local-by-flywheel/

2 Likes

With new versions I think since 5.6 or so (I’m running 5.7.4) port number is not available anymore. At least not when router is in site domains. I post this as a response since this was the best solution for using phpMyAdmin but it cost me a while to see that now I have to use the socket instead of the port. So maybe this will help someone else. The actual new code will be something like this:

/**

  • Second server
    */
    $i++;
    $cfg[‘Servers’][$i][‘verbose’] = ‘site_name’;
    $cfg[‘Servers’][$i][‘host’] = ‘localhost’;
    $cfg[‘Servers’][$i][‘socket’] = ‘/Users/username/Library/Application Support/Local/run/3YDAszCCj/mysql/mysqld.sock’;
    $cfg[‘Servers’][$i][‘connect_type’] = ‘tcp’;
    $cfg[‘Servers’][$i][‘extension’] = ‘mysqli’;
    $cfg[‘Servers’][$i][‘auth_type’] = ‘cookie’;
    $cfg[‘Servers’][$i][‘AllowNoPassword’] = false;

Please note that socket information is listed in the database tab for each website

1 Like

This worked for me, thanks @DigitalTojo! That’s the only option for me now, I get ERR_CONNECTION_REFUSED error when I’m trying to access Adminer via link available in Local’s dashboard (on Ubuntu).

Any movement on this or do I have to go back to MAMP? Not a threat, just a question.

I hope this isn’t the thing that pushes you to MAMP, but if I’m being honest, this likely won’t be done anytime soon.

I know that many are familiar with PHPMyAdmin over Adminer, but are there specific pieces of functionality that Adminer is missing that is only found in PHPMyAdmin?