Page 2 of 3
Re: [GUIDE] How to replace phpMyAdmin by Adminer in Ubuntu 16.04 NGINX php-fpm
Posted: Fri Jan 05, 2018 11:17 am
by rhyker2u
addendum ... as I love linking 'cross-posting' solutions together. Even adminer ain't perfect when migrating databases to a new VestaCP server. Hence I highly recommend to read
this VestaCP forum post on cli commands to migrate databases.
Re: [GUIDE] How to replace phpMyAdmin by Adminer in Ubuntu 16.04 NGINX php-fpm
Posted: Sun Mar 18, 2018 12:06 pm
by rhyker2u
Tip: Instead of having to run:
Code: Select all
sudo wget "https://www.adminer.org/latest.php" -O /usr/share/adminer/latest.php
manually at each and every update -- of which there have been two after
creating the 1st post -- it's easier to create a cronjob for it. ;-)
Re: [GUIDE] How to replace phpMyAdmin by Adminer in Ubuntu 16.04 NGINX php-fpm
Posted: Sun Apr 08, 2018 6:44 pm
by jasland
When I import with adminer after a minute or two, it gives 500 error
regards
Re: [GUIDE] How to replace phpMyAdmin by Adminer in Ubuntu 16.04 NGINX php-fpm
Posted: Tue Apr 10, 2018 8:34 am
by jasland
When I import with adminer after one or two minutes, an error of 500 occurs.
The same thing happens when I try to move tables from one base to another.
Anyone else get this, is there a solution?
regards
Re: [GUIDE] How to replace phpMyAdmin by Adminer in Ubuntu 16.04 NGINX php-fpm
Posted: Sat Sep 08, 2018 1:52 pm
by rhyker2u
skurudo wrote: ↑Tue Apr 18, 2017 7:34 am
rhyker2u wrote:Life is bliss again!
Only for nginx+php-fpm, sadly ;-)
You know whats really sad? That
the same phpmyadmin errors as in the 1st post are occuring still at the current / latest VestaCP (v0.9.8-22) on a default Vultr Ubuntu 18.04 installation. :-p but yes you're right; the adminer replacement cli syntax suggestion does only work on nginx+php-fpm. Quick-fix / hack for Apache2 (with or without nginx as caching) seems to be to edit:
Code: Select all
nano /etc/apache2/conf.d/phpmyadmin.conf
And make these changes:
Code: Select all
#Alias /phpmyadmin /usr/share/phpmyadmin
Alias /phpmyadmin /usr/share/adminer
Far from perfect -- as commenting out other stuff is probably smart -- but it works. ;-)
With regards to ...
jasland wrote: ↑Tue Apr 10, 2018 8:34 am
When I import with adminer after one or two minutes, an error of 500 occurs.
The same thing happens when I try to move tables from one base to another.
Anyone else get this, is there a solution?
regards
What kind of error 500? Being a little more specific sure helps ;-) However I always edit php.ini to support importing large DBs. And just got an error too when importing. Applying this fix
https://stackoverflow.com/a/104176 pertaining MySQL error 1153 did the trick ( or override it in /etc/mysql/mysql.conf at line nr 23).
Re: [GUIDE] How to replace phpMyAdmin by Adminer in Ubuntu 16.04 NGINX php-fpm
Posted: Tue Mar 05, 2019 1:50 pm
by realjumy
Is anyone brave enough to create this as a plugin/addon for VestaCP?
Re: [GUIDE] How to replace phpMyAdmin by Adminer in Ubuntu 16.04 NGINX php-fpm
Posted: Thu Mar 28, 2019 11:17 pm
by dreiggy
I have added Adminer pull request to installer as additional option:
https://github.com/serghey-rodin/vesta/pull/1847
Now vesta developers should decide if merge it.
Manual installation of Adminer (CentOS)
All these steps should be done as root user. Adminer will be installed beside phpMyAdmin. So you would be able to use both. If you want, you may remove phpMyAdmin manually.
Adminer installation:
Code: Select all
mkdir -p /usr/share/adminer
wget "https://www.adminer.org/latest.php" -O /usr/share/adminer/index.php
NGINX:
Code: Select all
echo "location /adminer {
alias /usr/share/adminer/;
location ~ ^/adminer/(.*\.php)$ {
alias /usr/share/adminer/$1;
fastcgi_pass 127.0.0.1:9000;
fastcgi_index index.php;
include fastcgi_params;
fastcgi_param SCRIPT_FILENAME $request_filename;
}
}
" > /etc/nginx/conf.d/adminer.inc
APACHE:
Code: Select all
echo "Alias /Adminer /usr/share/adminer
Alias /adminer /usr/share/adminer
<Directory /usr/share/adminer/>
Order Deny,Allow
Deny from All
Allow from All
</Directory>
" > /etc/httpd/conf.d/adminer.conf
Reload or restar nginx and apache:
Code: Select all
service nginx restart && service httpd restart
Re: [GUIDE] How to replace phpMyAdmin by Adminer in Ubuntu 16.04 NGINX php-fpm
Posted: Wed Apr 17, 2019 12:16 pm
by Spheerys
I'm runing with apache2 and I switch to Adminer to several servers with success.
I follow my own small guide :
mkdir /usr/share/adminer
wget
https://www.adminer.org/latest-mysql.php -O /usr/share/adminer/index.php
wget
https://raw.githubusercontent.com/vrana ... dminer.css -O /usr/share/adminer/adminer.css
sed -i -e "s/\/usr\/share\/phpmyadmin/\/usr\/share\/adminer/" /etc/nginx/conf.d/phpmyadmin.inc
sed -i -e "s/\/usr\/share\/phpmyadmin/\/usr\/share\/adminer/" /etc/apache2/conf.d/phpmyadmin.conf
sed -i -e "s/php_admin_value/#php_admin_value/" /etc/apache2/conf.d/phpmyadmin.conf
systemctl restart nginx.service apache2.service
apt remove phpmyadmin
But I have a problem with the last server !
Maybe due to the removing of phpmyadmin : the system ask me about removing some phpmyadmin stuff and maybe I have answered the wrong anwser !!!
Now, when I'm trying to log in Adminer with correct user/pass I get this error :
Code: Select all
Access denied for user 'User_test'@'localhost' (using password: NO)
The mysql server running well by the way and I can connect from cli with
How to solve the problem ?
Re: [GUIDE] How to replace phpMyAdmin by Adminer in Ubuntu 16.04 NGINX php-fpm
Posted: Fri May 17, 2019 8:46 am
by Nadayan
So that it works correctly phpmyadmin cannot be deleted? Or is this not the case?
Re: [GUIDE] How to replace phpMyAdmin by Adminer in Ubuntu 16.04 NGINX php-fpm
Posted: Mon Mar 16, 2020 2:06 am
by shally87
Thanks!
Works for CentOS too.