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)