Adminer the simple phpmyadmin replacement

[viking60]

I have often struggled with setting up phpmyadmin to populate my Mysql/MariaDB databases - and mostly I manage. But everytime I set up a new server I have to do some research to make it work.

After a while you get some experience - so you can manage. Well if you always set up the same server type like Apache.

I wanted to try out the nginx server which cannot do everything Apache does; but those six things that you need are done 50 times faster!

I'll get back to nginx but the point here is that I got nginx up and running with php and MariaDB so I was almost home free - but that phpmyadmin would not play along - as usual.

There is no way a professional that has to manage databases for different clients can handle that with phpmyadmin - I thought. There must be a simpler, out of the box, solution that does not require a double somersault to make it work.

And there is:
Adminer is a basically a single file that you can upload to your server and manage your databases right away (and delete it after you are finished -if you so desire).
To good to be true? I thought so - but it works

Naturally you have to have a working php and mysql/MariaDB installation - many distros have a LAMP meta-package for that. I will not go further into that here (but - as always -feel free to ask).

I made a directory under my server called adminer and put one single file in there the adminer index.php.
My server is under ~/public_html so adminer is now in

Code: Select all

~/public_html /adminer

After that I go to

Code: Select all

http://localhost/adminer

in my browser and by a miracle I can log in and handle my databases there.

To get a different look and feel you can add one file in the same directory called adminer.css and fill it with the content of one of the styles presented here (under Alternative designs).
My adminer looks like this now:

This is one of the best pieces of software I have stumbled over in a long time so i think I will officially recommend it now:

[dedanna1029]

Nice!

Just out of curiosity, what kind of space does the server for bjoernvold's forum take (currently) hard drive-wise, and is Adminer handling it as well?

[viking60]

Yup the adminer works perfectly on bjoernvold.com.
And bjoernvold com is bloated with a lot of my experiments so it takes about 400MB.

This forum does not take much. The CMS on the front page is my development/programing and I keep adding stuff to it so it gets big even if it not is visible to you and much of it will probably never be.
And then there are several versions etc..

PS the code of my Content management system on the front page is encrypted for security reasons - but with a message on the top of the page that anybody who wants the code can mail me.

[dedanna1029]

Interesting...