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.
Top comments (0)