How to Install PHPMyAdmin on Your Cloudways Server?

PHPMyAdmin is a handy tool for managing your databases, and having it installed on your Cloudways server can significantly improve your workflow. In this guide, we’ll walk you through the process of installing PHPMyAdmin on your Cloudways server. Don’t worry if you’re not a tech wizard – we’ll take it step by step, making sure you understand each stage of the process.

We’ll be focusing on setting up PHPMyAdmin on a separate PHP Stack application, which is a recommended approach for this kind of installation. If you’re ready to begin, let’s dive in!

Step 1: Creating a New PHP Custom App

Our first step involves connecting to your PHP Stack application.

If you don’t already have one, log in to your Cloudways account, choose your server, and under “Quick Actions,” click “Add Application.” From under the “Select Application” dropdown, choose “Custom App.” Enter a name for your application, select a project, and then click “Add Application.”

Step 2: Dialing into Your Application

To do this, we’ll use Secure Shell (SSH), a secure network protocol that allows you to access and control your server remotely. Here’s how to get started:

1. Connect to your Custom App using SSH. You can find numerous tutorials online if you’re unsure how to do this.
2. Once connected, navigate to the public_html folder with the following command: cd applications/yourfoldername/public_html. Replace yourfoldername with the name of your Custom App.

Step 3: Cloudways PHPMyAdmin Installation

Now that we’re connected and in the right directory, we’re ready to download PHPMyAdmin. Follow these steps:

1. Check the PHPMyAdmin website to find the most recent version of PHPMyAdmin. This is crucial because we want to download the latest version to ensure we have all the new features and security updates.
2. Use the following command to download PHPMyAdmin: wget https://files.phpmyadmin.net/phpMyAdmin/version/phpMyAdmin-version-english.zip. Replace version with the version number, you found on the PHPMyAdmin website. For example, wget https://files.phpmyadmin.net/phpMyAdmin/5.2.0/phpMyAdmin-5.2.0-english.zip
3. Unzip the downloaded file with this command: unzip phpMyAdmin-version-english.zip. Replace the version with the version number you found on the PHPMyAdmin website. For example, unzip phpMyAdmin-5.2.0-english.zip
4. After unzipping, we’ll rename the PHPMyAdmin folder to something more manageable. Use this command: mv phpMyAdmin-version-english phpmyadmin. For example, mv phpMyAdmin-5.2.0-english phpmyadmin

And that’s it! You’ve successfully installed PHPMyAdmin on your Cloudways server. You can now locate and access this folder from your browser to start using PHPMyAdmin. The URL will be in this format: http://phpstack-xyz.cloudwaysapps.com/phpmyadmin. Replace xyz with your specific Custom App details.

Something to Keep in Mind

If you’re dealing with databases on multiple servers and you need to use PHPMyAdmin, remember you’ll need to install PHPMyAdmin on each server separately. This ensures smooth and secure access to all your databases.

And there you have it, a comprehensive guide to installing PHPMyAdmin on your Cloudways server. We hope you found this walkthrough helpful and straightforward. If you have any questions or run into any issues, don’t hesitate to reach out.