{"id":2661,"date":"2023-08-30T22:47:37","date_gmt":"2022-08-21T09:26:04","guid":{"rendered":""},"modified":"2025-02-02T00:46:19","modified_gmt":"2025-02-01T23:46:19","slug":"how-to-install-phpmyadmin-with-nginx-and-let-039-s-encrypt-ssl-on-ubuntu-24-04","status":"publish","type":"post","link":"https:\/\/netcloud24.com\/knowledgebase\/how-to-install-phpmyadmin-with-nginx-and-let-039-s-encrypt-ssl-on-ubuntu-24-04\/","title":{"rendered":"Linux VPS & VPS Windows Setup Guide | NetCloud24 PhpMyAdmin with Nginx and Let's Encrypt SSL on Ubuntu 24.04"},"content":{"rendered":"

\u00a0<\/p>\n<\/p>\n

\n

\u00a0<\/h1>\n<\/header>\n
\n

PhpMyAdmin is a popular web-based tool used to manage MySQL and MariaDB databases. When combined with Nginx and secured using Let’s Encrypt SSL, it provides a powerful, secure way to manage your databases. In this guide, we’ll walk through the process of installing PhpMyAdmin on Ubuntu 24.04 with Nginx and securing it using a free Let’s Encrypt SSL certificate. This setup is ideal for both local servers and VPS servers<\/strong>.<\/p>\n

Step 1: Update Your System<\/h2>\n

Before installing any packages, it’s important to ensure your Ubuntu 24.04 server is up to date. Run the following command to update the package list and upgrade any outdated packages:<\/p>\n

sudo apt update && sudo apt upgrade -y<\/code><\/pre>\n
Step 2: Install Nginx and PHP<\/h2>\n
Next, install Nginx and PHP, which are required for PhpMyAdmin to function:<\/p>\n
sudo apt install nginx php-fpm php-mysql -y<\/code><\/pre>\n
Once the installation is complete, start and enable Nginx:<\/p>\n
sudo systemctl start nginx\r\nsudo systemctl enable nginx<\/code><\/pre>\n
Step 3: Install PhpMyAdmin<\/h2>\n
PhpMyAdmin is not included in the default Ubuntu repositories, so you’ll need to download it manually. Begin by navigating to your web directory:<\/p>\n
cd \/var\/www\/html<\/code><\/pre>\n
Download the latest version of PhpMyAdmin using the following command:<\/p>\n
wget https:\/\/www.phpmyadmin.net\/downloads\/phpMyAdmin-latest-all-languages.tar.gz<\/code><\/pre>\n
Extract the downloaded file:<\/p>\n
sudo tar xvf phpMyAdmin-latest-all-languages.tar.gz<\/code><\/pre>\n
Rename the extracted directory to “phpmyadmin” for simplicity:<\/p>\n
sudo mv phpMyAdmin-*-all-languages phpmyadmin<\/code><\/pre>\n
Change the ownership of the PhpMyAdmin directory to the Nginx user:<\/p>\n
sudo chown -R www-data:www-data \/var\/www\/html\/phpmyadmin<\/code><\/pre>\n
Step 4: Configure Nginx for PhpMyAdmin<\/h2>\n
Create a new Nginx server block for PhpMyAdmin:<\/p>\n
sudo nano \/etc\/nginx\/sites-available\/phpmyadmin.conf<\/code><\/pre>\n
Add the following configuration to the file:<\/p>\n
\r\nserver {\r\n    listen 80;\r\n    server_name your_domain;\r\n\r\n    root \/var\/www\/html\/phpmyadmin;\r\n    index index.php index.html index.htm;\r\n\r\n    location \/ {\r\n        try_files $uri $uri\/ =404;\r\n    }\r\n\r\n    location ~ \\.php$ {\r\n        include snippets\/fastcgi-php.conf;\r\n        fastcgi_pass unix:\/var\/run\/php\/php-fpm.sock;\r\n    }\r\n\r\n    location ~ \/\\.ht {\r\n        deny all;\r\n    }\r\n}\r\n        <\/code><\/pre>\n
Save and exit the file. Enable the configuration by creating a symbolic link:<\/p>\n
sudo ln -s \/etc\/nginx\/sites-available\/phpmyadmin.conf \/etc\/nginx\/sites-enabled\/<\/code><\/pre>\n
Test the Nginx configuration for errors:<\/p>\n
sudo nginx -t<\/code><\/pre>\n
If the configuration is valid, restart Nginx to apply the changes:<\/p>\n
sudo systemctl restart nginx<\/code><\/pre>\n
Step 5: Secure PhpMyAdmin with Let’s Encrypt SSL<\/h2>\n
Next, secure PhpMyAdmin by installing a free SSL certificate from Let’s Encrypt. Begin by installing Certbot, the tool used to request and manage SSL certificates:<\/p>\n
sudo apt install certbot python3-certbot-nginx -y<\/code><\/pre>\n
Request an SSL certificate for your domain using Certbot:<\/p>\n
sudo certbot --nginx -d your_domain<\/code><\/pre>\n
Follow the on-screen instructions to complete the process. Certbot will automatically configure Nginx to use the SSL certificate and redirect HTTP traffic to HTTPS.<\/p>\n
Step 6: Verify SSL and PhpMyAdmin Setup<\/h2>\n
Once the SSL certificate is installed, you can verify the SSL setup by visiting your domain in a web browser using HTTPS:<\/p>\n
https:\/\/your_domain<\/code><\/pre>\n
You should see the PhpMyAdmin login page. Log in with your MySQL or MariaDB credentials to start managing your databases.<\/p>\n
Step 7: Enable Automatic SSL Renewal<\/h2>\n
Let’s Encrypt SSL certificates expire after 90 days. To ensure your certificate is automatically renewed, add a cron job to run the renewal process regularly:<\/p>\n
sudo crontab -e<\/code><\/pre>\n
Add the following line to renew the certificate automatically:<\/p>\n
0 0 * * * \/usr\/bin\/certbot renew --quiet<\/code><\/pre>\n
Using PhpMyAdmin on a VPS Server<\/h2>\n
If you’re running a VPS server<\/strong>, installing PhpMyAdmin with Nginx and Let’s Encrypt SSL ensures that you can securely manage your MySQL databases. By combining the flexibility of Nginx with the security of free SSL from Let’s Encrypt, your VPS<\/strong> environment remains protected while providing easy access to your database administration.<\/p>\n
Looking for a Reliable VPS Solution?<\/h2>\n
If you’re looking for a secure and reliable VPS server<\/strong> to run PhpMyAdmin and manage your databases, consider using . With Windows VPS<\/strong>, you get scalable VPS hosting that ensures your applications run smoothly with full security and performance optimization.<\/p>\n