DEV Community

Cover image for Adminer! A useful and very simple alternative to PhpMyAdmin

Adminer! A useful and very simple alternative to PhpMyAdmin

Anderson Brandão on October 02, 2017

I had some... issues with phpmyadmin. This was a good oportunity to look for an alternative. After trying out some options, luckily I found the Adm...
Collapse
 
kodierkroete profile image
Steffen Frosch

Hi,

as i am not a great fan of these tools, i would like to point out some alternatives. Sequel Pro if you are using a mac or HeidiSQL on windows (with wine on mac and linux too) or multi platform MySQL Workbench.

These tools are available for free and offer all the functionality you need. You can use SSH connections to connect to remote hosts and you wont compromise your server (or dev machine) when there is a security issue.

Collapse
 
abrandao profile image
Anderson Brandão

I agree. There is most powerfull tools. I am not using Adminer on production. I like Adminer so much just because it's a single file with all resources I need.

Collapse
 
kodierkroete profile image
Steffen Frosch

And nothing wrong with it. I wanted to add a word of caution because i've seen these things in production myself. And it didn't end well. So if it works for you great ;) And i can totally relate to a configuration fatigue. The easier a tool is to use the better for us!

Collapse
 
bgadrian profile image
Adrian B.G.

Wait PhpMyAdmin is not simple? I think by using it for so long I got used to it.

Anyway another simple alternative are the official tools

Collapse
 
abrandao profile image
Anderson Brandão

I didn't say PhpMyAdmin is not simple. I just show a very(dont need to install) simple alternative.

Thanks for comment.

Collapse
 
bgadrian profile image
Adrian B.G. • Edited

Adminer is way simpler indeed, but because it removes many the functionalities and settings, but is more versatile.

Anyway I use and recommend using docker for development environments, for many obvious reasons.

#https://hub.docker.com/r/phpmyadmin/phpmyadmin/
docker run --name myadmin -d -e PMA_HOST=dbhost -p 8080:80 phpmyadmin/phpmyadmin
#https://hub.docker.com/_/adminer/
docker run --link some_database:db -p 8080:8080 adminer
Thread Thread
 
abrandao profile image
Anderson Brandão

Thanks. I am using docker and Adminer.

Collapse
 
anujshr profile image
AnujShr

Adminer is just great. Less hassle to install and supports everything you need. Except you need some heavy duty things.

Collapse
 
gluseppe profile image
Giuseppe Frau

So simple to get it working. I use it with postgresql and I just love it.

Collapse
 
mnlwldr profile image
manuel

I use adminer every day. I like it because it’s only one php file and easy to use with the php builtin server