#Aws ubuntu install phpmyadmin how to
#Aws ubuntu install phpmyadmin install

Here is the Nginx configuration to do the same. I have created a separate port based virtual host in Nginx for phpmyadmin so that I can access it over a special port.

#Aws ubuntu install phpmyadmin install

In my case it is an AWS EC2 instance and when I launch an instance it prompts to create a key pair (or use existing key pair), through which I can access the server through SSH client like Putty on windows or equivalent tools in Linux.Įnsure you are able to connect successfully with your server through SSH Step 2: Create a separate virtual-host for phpMyAdmin Setup and install MySQL Server in the cloud on Azure, AWS or GCP using the LAMP stack on any of the cloud platforms that includes MySQL Server, Apache Web Server, PHP, PHPMyadmin running on either Ubuntu 20.

#Aws ubuntu install phpmyadmin how to

If you don’t know how to generate a public/private key pair for your server an quick google search will give you lot of nice tutorials on this topic. To access it from a remote system, you must create an SSH tunnel. You should be able to access your remote server through SSH using a public-private key pair. For security reasons, phpMyAdmin is accessible only when using 127.0.0.1 as the hostname. Step 1: Create a Public/Private Key pair to securely access your Server We can make it possible through some Nginx configurations (or Apache if you have one) and through some SSH tunneling. Ideally I would like to make it accessible only to me from anywhere (from my home or office) but not make it available to other preying eyes. sudo apt update sudo apt install phpmyadmin. Normally without any security (or with some basic security) in place it would be available openly on some public URL like this. Download and Install phpMyAdmin on Ubuntu 20.04.

I have setup phpMyAdmin on the same server so that I can quickly do some database stuff for my website. In this article I am going to show you how you can secure your phpMyAdmin installation from the outside unauthorized access but still available online over the Internet just for you to access.įor the purpose of this article I have setup a LEMP stack (Linux, Nginx, MySQL & PHP) on an Amazon EC2 instance which basically hosts a tiny WordPress website. However having just a password protected phpMyAdmin access on a public URL is very risky as you are potentially giving a full database access of your app to some intruder. Here you get to choose the OS for the virtual machine and also the other hardware. This helps us to quickly check the database, run few queries or do some maintenance work. The phpMyAdmin documentation comes installed with the package and can be accessed from the phpMyAdmin Documentation link (a question mark with a box around it). Clicking on the option from Step 1 takes to the below page.

Often it is convenient to have an easy access to your database through some client like phpMyAdmin on the server where your app or website is installed.