[GUIDE] How to replace phpMyAdmin by Adminer in Ubuntu 16.04 NGINX php-fpm

[rhyker2u]

After a pletora of strange recurring phmyadmin errors like:
- feature/controlusers viewtopic.php?f=14&t=10307
- gettext errors (supposedly due to php7?)
- deprecated notices of all sorts
- strange 403 errors after an update (probably due to blowfish keys being shorter than recommended 32 chars, but whatever I tried couldn't get it work)

Thus I decided to replace phpmyadmin by https://www.adminer.org ... with a twist (to keep the phpmyadmin link working in VestaCP backend). Perform from terminal:

Code: Select all

sudo mkdir /usr/share/adminer
sudo wget "https://www.adminer.org/latest.php" -O /usr/share/adminer/latest.php
sudo ln -s /usr/share/adminer/latest.php /usr/share/adminer/index.php
sudo nano /etc/nginx/conf.d/phpmyadmin.inc

replace two occurrences of /usr/share/phpmyadmin/ by /usr/share/adminer/
restart webserver ... and done!

Code: Select all

sudo apt remove phpmyadmin
sudo apt autoremove

Life is bliss again!

[rhyker2u]

Question: if VestaCP is all about making things easy & lightweight, then why on earth is adminer not part of the default VestaCP package?! Saves soooo many problems, headaches, overhead and what not. Or at least make it an option in the advanced install script please. See detailed comparison: https://www.adminer.org/en/phpmyadmin/

P.S. I didn't know about adminer till I was about to give up on VestaCP. Things happen for a reason I suppose ;-)

[skurudo]

Life is bliss again!

Only for nginx+php-fpm, sadly ;-)

[skurudo]

Question: if VestaCP is all about making things easy & lightweight, then why on earth is adminer not part of the default VestaCP package?! Saves soooo many problems, headaches, overhead and what not. Or at least make it an option in the advanced install script please. See detailed comparison: https://www.adminer.org/en/phpmyadmin/

phpmyadmin it's historical choice, and was made when adminer not so popular.

Adminer pretty nice.
Well, we thought about this. And some time ago made idea, but not so many votes for adminer - https://bugs.vestacp.com/issues/145
;-(

[nik]

Hi Rhyker2u

Many , many thanks for your post on how to replace phpMyAdmin /w Adminer
which I have been using without any CP
I have been using VestaCP since day 1 . My fav CP , until problems with phpMyAdmin
Thanks to you I am now back on VestaCP

Kind Regards
Nik

[rhyker2u]

@skurudo: Ask anyone whom has used PhpMyAdmin in the past decade if they would like to use something else, and the answer will always be no. Different example: would you like to have an easier more lightweight webhosting control panel called VestaCP to replace Cpanel / DirectAdmin / Plesk? "Ehhh does that entail learning new things? No then I want to stick to what I know" :-p NGINX similar. It's not that I wanted to, my hand was forced and now I will never ever go back to Apache2 nor any other CP. ;-)

And a small addendum to my opening post: after doing the steps above, edit /etc/nginx/conf.d/phpmyadmin.inc again to replace the first line by these 3.

Code: Select all

location /phpmyadmin {
   allow X.X.X.X;
   deny all;

Where X.X.X.X == https://www.whatismyip.com

As I just used my own howto on a new server setup, and knew there was something I forgot for additional security tightening. Also see viewtopic.php?f=10&t=14346&p=60358#p60358 for more post-install tips.

[skurudo]

@skurudo: Ask anyone whom has used PhpMyAdmin in the past decade if they would like to use something else, and the answer will always be no. Different example: would you like to have an easier more lightweight webhosting control panel called VestaCP to replace Cpanel / DirectAdmin / Plesk? "Ehhh does that entail learning new things? No then I want to stick to what I know" :-p NGINX similar. It's not that I wanted to, my hand was forced and now I will never ever go back to Apache2 nor any other CP. ;-)

@rhyker2u it's not a deal about adminer... we'd like to add new and more, there is time matter and not such much free time ;-(

[kinnth]

How do you connect to adminer via the web gui? usually I connect to phpmyadmin via www.mysite.com/phpmyadmin I wondered if there was a way to do the same for adminer?

[skurudo]

How do you connect to adminer via the web gui? usually I connect to phpmyadmin via http://www.mysite.com/phpmyadmin I wondered if there was a way to do the same for adminer?

Similar way as phpmyamin

[rhyker2u]

How do you connect to adminer via the web gui? usually I connect to phpmyadmin via http://www.mysite.com/phpmyadmin I wondered if there was a way to do the same for adminer?

Similar way as phpmyamin

No ... the EXACT same way. @kinnth : just follow instructions in the 1st post. Or create a second entry for adminer to have both (and to make things more complicated); I prefer easy :-p