How to setup PHPMyAdmin with Nginx on Ubuntu

Samuel John — Thu, 22 Jun 2023 23:33:54 +0000

What is PHPMyAdmin? It is an open source tool written in the PHP programming language and it is useful for handling the administration of MySQL/MariaDB database servers over the Web. It possess a simple interface that is easy to navigate and learn quickly.

What is Nginx? Nginx is an open source software that is used mainly as a web server, reverse proxy, cache server. It is also used as a load balancer, for media streaming, etc.

Now to the topic of discussion for today...
How do I setup PHPMyAdmin with nginx on my ubuntu server?

Step 1: Install needed tools

Before installing PHPMyAdmin, make sure you have installed and configured mysql/mariadb and nginx

sudo apt update && sudo apt upgrade
sudo apt install zip
mkdir -p /var/www/phpmyadmin
cd /var/www/phpmyadmin
wget https://www.phpmyadmin.net/downloads/phpMyAdmin-latest-all-languages.zip
unzip phpMyAdmin-latest-all-languages.zip
cp -a phpMyAdmin-5.2.1-all-languages/. .
rm -rf phpMyAdmin-5.2.1-all-languages
rm -rf phpMyAdmin-5.2.1-all-languages.zip

Step 2: Configure Nginx virtualhost

sudo vim /etc/nginx/conf.d/vhost.conf
server {
    listen         80 default_server;
    listen         [::]:80 default_server;
    server_name    _;
    root           /var/www/phpmyadmin;
    index          index.php;

    location / {
      #try_files $uri $uri/ =404;
      try_files $uri $uri/ /index.php?$args;        
    }

    location ~ \.php$ {
      include snippets/fastcgi-php.conf;
      fastcgi_pass unix:/run/php/php7.2-fpm.sock;
    }

    location ~ /\.ht {
      deny all;
    }

    location /phpmyadmin {
      alias /var/www/phpmyadmin;
      #try_files $uri $uri/;

      location ~ \.php$ {
        include snippets/fastcgi-php.conf;
        fastcgi_pass unix:/run/php/php7.2-fpm.sock;
        include fastcgi_params;                       
        fastcgi_param SCRIPT_FILENAME $request_filename;
        #fastcgi_intercept_errors on;
      }
    }
}

Step 3: Test your PHPMyAdmin installation

Go to this url to test: http{s}://your-url/phpmyadmin

Thank you so much for your time. Make sure to check back on my blog for other amazing technical contents.

My favourite rsync commands

Samuel John — Tue, 12 Apr 2022 22:12:45 +0000

Below, i have collated some rsync commands that I use in my day-to-day system administration tasks.
I found rsync a better tool compared with other FTP/SFTP tools that I have used in the past. (FileZilla was my goto tool in the past).

Another thing that fascinated me and attracted me to using rsync was the need to carry out all my sysadmin/development tasks inside one gui using an IDE (I fell in love with VSCode as my favourite).

Now, let's begin:

Rsync command to copy a file/folder from local pc to a remote server

With key/certificate

$ rsync -iav /path/to/keyfile/key.pem /local/directory/path/ user@example.com:/remote/directory/path/

Without key/certificate

$ rsync -iv /local/directory/path/ user@example.com:/remote/directory/path/

Rsync command to copy a file/folder from remote pc/server to a local pc/server

With key/certificate

$ rsync -avzP --rsh=ssh user@example.com:/remote/directory/path/ /local/directory/path/

Without key/certificate

$ rsync -avzP --rsh=ssh user@example.com:/remote/directory/path/ /local/directory/path/

Rsync command to copy a file/folder from remote pc/server to another remote pc/server

$ rsync -i /path/to/keyfile/key.pem user@example.com:/path/to/file.txt user@example.org:/path/to/file

DEV Community: Samuel John

How to setup PHPMyAdmin with Nginx on Ubuntu

Step 1: Install needed tools

Step 2: Configure Nginx virtualhost

Step 3: Test your PHPMyAdmin installation

My favourite rsync commands

Rsync command to copy a file/folder from local pc to a remote server

With key/certificate

Without key/certificate

Rsync command to copy a file/folder from remote pc/server to a local pc/server

With key/certificate

Without key/certificate

Rsync command to copy a file/folder from remote pc/server to another remote pc/server