Скачать или смотреть How to Set Up phpMyAdmin in a Subdirectory on an NGINX Server

A step-by-step guide on configuring phpMyAdmin in a subdirectory to enhance your web server management and secure your connections with SSL.
---
This video is based on the question https://stackoverflow.com/q/62360907/ asked by the user 'Shoumik Das' ( https://stackoverflow.com/u/11689213/ ) and on the answer https://stackoverflow.com/a/62362487/ provided by the user 'Ivan Shatsky' ( https://stackoverflow.com/u/7121513/ ) at 'Stack Overflow' website. Thanks to these great users and Stackexchange community for their contributions.

Visit these links for original content and any more details, such as alternate solutions, latest updates/developments on topic, comments, revision history etc. For example, the original title of the Question was: Setup phpMyAdmin inside website subdirectory

Also, Content (except music) licensed under CC BY-SA https://meta.stackexchange.com/help/l...
The original Question post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license, and the original Answer post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license.

If anything seems off to you, please feel free to write me at vlogize [AT] gmail [DOT] com.
---
How to Set Up phpMyAdmin in a Subdirectory on an NGINX Server

If you're managing a web server using NGINX, you may find yourself needing to set up phpMyAdmin in a specific subdirectory rather than its default location. This guide provides a clear step-by-step guide for achieving this, allowing you to access the phpMyAdmin login page directly through your domain (e.g., domain1.com/phpMyAdmin/), while enhancing security with HTTPS.

Understanding the Problem

You have an NGINX web server running two domains, and phpMyAdmin is already functioning properly at its default address: public-ip-address/phpMyAdmin. However, you want to make it more convenient and secure by accessing it via your own domain, specifically under domain1.com/phpMyAdmin/. Here’s how to set that up, particularly focusing on ensuring that your phpMyAdmin interface is secured with SSL as well.

Current Configuration

Your Existing Server Block

Your server block for domain1.com looks something like this:

[[See Video to Reveal this Text or Code Snippet]]

This configuration ensures that your site is served correctly and that SSL is enforced. However, it doesn’t include a location for phpMyAdmin yet.

Step-by-Step Solution

Adding a location block for phpMyAdmin

To incorporate phpMyAdmin into your server configuration, you will need to add a specific location block designed to handle phpMyAdmin requests. Here’s what you need to do:

Open your NGINX server block configuration file:

This will typically be located in /etc/nginx/sites-available/domain1.com.

Add the following location block before the default PHP handler:

[[See Video to Reveal this Text or Code Snippet]]

Important Placement

Make sure that this location block is placed before the default PHP handler block. This step is critical because if it is placed after, requests to phpMyAdmin may be incorrectly handled by the default PHP processing rules, preventing access to phpMyAdmin entirely.

Final Steps: Testing Your Configuration

After making these changes, it’s important to restart or reload your NGINX server for the updates to take effect. You can do this with the following command:

[[See Video to Reveal this Text or Code Snippet]]

Next, navigate to https://domain1.com/phpMyAdmin/ in your web browser to access the login page. This should now securely route you to the phpMyAdmin interface using your SSL certificate.

Conclusion

Setting up phpMyAdmin in a subdirectory on an NGINX server is straightforward if you carefully follow the steps provided above. Not only does this improve accessibility by aligning it with your primary domain, but it also enhances security through HTTPS. By ensuring proper configuration of your server blocks, you'll have a seamless experience managing your databases.

Additional Tips

Always backup your configuration files before applying changes.

Keep your phpMyAdmin and PHP versions up to date to avoid vulnerabilities.

Regularly check your server logs for any issues after making changes to your configurations.

Feel free to explore additional NGINX capabilities as you grow your web server management skills. Happy managing!