Linode Forum
Linode Community Forums
 FAQFAQ    SearchSearch    MembersMembers      Register Register 
 LoginLogin [ Anonymous ] 
Post new topic  Reply to topic
Author Message
PostPosted: Tue Dec 17, 2013 4:55 pm 
Offline
Newbie

Joined: Fri Oct 11, 2013 1:55 pm
Posts: 4
Hello,

I am running a LEMP server on my linode, set up according to the walkthrough ( https://library.linode.com/lemp-guides/ ... e-pangolin )

I currently have several sites running and I want a gui to manage mySQL. I've begun to install phpmyadmin (using https://library.linode.com/databases/my ... 04-precise as a reference). When I run

sudo apt-get install phpmyadmin

I am asked which server to automatically configure phpMyAdmin for but nginx is not an option - my two options are "apache2" and "lightlpd" (I'm thinking I have these installed from some initial tinkering I did while finding a suitable web server configuration.) I am running all of my websites + databases on nginx so I am confused why "nginx" doesn't appear in the phpmyadmin configuration option.

Does anyone have a reliable set of instructions for installing phpmyadmin on a LEMP server that has several active databases?

I definitely don't want to muck up my server or lose database information.


Top
   
PostPosted: Wed Dec 18, 2013 8:56 am 
Offline
Senior Member

Joined: Fri Feb 17, 2012 8:20 pm
Posts: 365
You can just download phpmyadmin from the site, create a vhost for it in nginx manually and upload the files there. There's no need to do it through apt-get.


Top
   
PostPosted: Wed Dec 18, 2013 7:29 pm 
Offline
Newbie

Joined: Tue Oct 15, 2013 3:41 pm
Posts: 4
I'd recommend doing phpmyadmin via apt-get from a security point of view/ease of management. You just need to do the server configuration yourself which is not hard. I'd even do the apache2 configuration myself... Everyone in the world having the default configuration, and therefore default location for phpmyadmin is a bit of a risk.

In nginx it's simple, something like this is a good starting point (from http://magnatecha.com/set-up-phpmyadmin-with-nginx/):

Code:
    server {
        listen          81;
        server_name     localhost;
        root        /usr/share/phpmyadmin;
        index       index.php index.html index.htm;
        if (!-e $request_filename) {
            rewrite ^/(.+)$ /index.php?url=$1 last;
            break;
        }
        location ~ .php$ {
            try_files $uri =404;
            fastcgi_pass unix:/var/run/php5-fpm.sock;
            fastcgi_index index.php;
            include /etc/nginx/fastcgi_params;
        }
    }


Don't just copy and paste that code, I'm assuming you know a little bit about about nginx/php-fpm etc. You'll need to adjust the lines appropriately to your needs and I'd suggest adding additional levels of security (ip address allow/deny at a min).


Top
   
Display posts from previous:  Sort by  
Post new topic  Reply to topic


Who is online

Users browsing this forum: No registered users and 3 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
RSS

Powered by phpBB® Forum Software © phpBB Group