EasyEngine users can install phpMyAdmin quickly with command
ee stack install --phpmyadmin
Since phpMyAdmin does not ship with all the dependancies anymore, you will have install the dependancies manually with the following commands.
Note that you will have to install Composer for these commands to work.
cd /var/www/22222/htdocs/db/pma/ composer install --no-dev
Non EasyEngine Users will have to follow below steps.
Installing PhpMyAdmin in a subdirectory
example.com site has PHP support enabled.
Run following commands:
cd /var/www/example.com/htdocs/ git clone https://github.com/phpmyadmin/phpmyadmin.git phpmyadmin cd phpmyadmin composer update --no-dev
It will install latest PhpMyAdmin which can be accessed from http://example.com/phpmyadmin
Installing PhpMyAdmin on a separate subdomain
You need to first create a site like
mysql.example.com site with PHP support. You can use this tutorial to create a virtual-host with PHP support. Just skip WordPress downloading and database setup part.
Then, run following commands:
Run following commands:
cd /var/www/example.com/htdocs/ git clone https://github.com/phpmyadmin/phpmyadmin.git . composer update --no-dev
This will install latest phpMyAdmin which can be accessed from http://mysql.example.com/
HI, I used your easy engine to ‘install all’ but it seems as if phpmyadmin is returning 403 access forbidden. Any ideas why it would do so?
To access phpmyadmin you have to add your ip address in following file
Replace 184.108.40.206 with your ip address and then reload nginx by using following command
You can access phpmyadmin by using example.com/pma
Thanks for the quick response. I now get this after restarting nginx:
nginx: configuration file /etc/nginx/nginx.conf test failed
Its seems like you try to reload nginx with non-privilege user try to run reload nginx with following command
Ok that worked for reloading nginx, but now It still shows 403 access forbidden
Disregard that, I had left
deny all;after my ip.
Thanks so much.
Just confirming that the
deny all;does indeed to be removed for this to work and still be secure?
deny allwill make your phpmyadmin accessible to everyone.
Its better to add your IP with allow line and keep
deny allas it is. This is assuming you have a static IP.
If you do not have a static IP, then you can remove
deny all. You can HTTP auth then to protect phpmyadmin area – http://wiki.nginx.org/HttpAuthBasicModule