How to install Adminer on a Nginx server running Ubuntu OS on it?

Posted on June 17, 2019

I have a LEMP droplet. Since phpmyadmin is not available in a Nginx server, I want to install Adminer so that i can manage my Wordpress database. Please include all the steps in your answer. I’ll be very thankful to you.

This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

alexdo

August 3, 2019

Hello,

I assume you already have MySQL installed so you would need to download adminer to your server.

You can use this script to install and configure adminer on your server:

https://gist.github.com/zloynemec/1e4680c4c9aa9cee8a6e#file-adminer_setup-sh

You can simply wget the script

wget https://gist.github.com/zloynemec/1e4680c4c9aa9cee8a6e#file-adminer_setup-sh

then make it executable:

chmod +x adminer_setup.sh

You will then have adminer available and you can access it via your preferred browser

You can also do this manually if you like by using the described steps in the script. It’s totally up to you.

Let us know how it goes.

Alex

FriendlyGreenBlueShark

September 6, 2022

Hi I have the solution you have to follow just some steps -

Create site-enables

/etc/nginx/sites-available

sudo nano dba

paste this code.

server { listen 80; listen [::]:80; root /var/www/dba; index index.php index.html index.htm; server_name dba; location / { try_files $uri $uri/ =404; }

pass PHP scripts to FastCGI server
 location ~ \.php$ {
         include snippets/fastcgi-php.conf;
# With php-fpm (or other unix sockets):
        fastcgi_pass unix:/var/run/php/php7.3-fpm.sock;
# With php-cgi (or other tcp sockets):

fastcgi_pass 127.0.0.1:9000;

} }