With phpMyAdmin, you can perform various operations on your databases, such as creating, editing, deleting, importing, exporting, etc. You can use phpMyAdmin to access any database that belongs to your web applications, as long as you have the database username and password.

How to Install phpMyAdmin

To install and access phpMyAdmin in RunCloud, follow these steps:

  1. Log in to your RunCloud dashboard and select the server that has the web applications that you want to access with phpMyAdmin.
  2. Create a new Web Application and select phpMyAdmin.
  3. Provide basic details such as the name, domain, PHP version, etc. You can use either a free domain or your own domain (or subdomain) for your phpMyAdmin web application.
  4. Click on Add Web Application and wait for RunCloud to install phpMyAdmin on your server.
  1. Once the installation has finished, click on the phpMyAdmin web application that you have created and click on the URL to launch it.
  2. You will then see a login page where you’ll need to enter your database username and password to access phpMyAdmin.
  1. If you don’t know your database username or password, you can find them in the configuration files of your web applications, such as wp-config.php for WordPress. You can use the File Manager feature in RunCloud to open and view these files.
  2. You can also find your database username by clicking on Database from the main navigation menu, and then clicking on the database that belongs to your web application.
  3. Once you enter the correct database username and password, you will see the phpMyAdmin interface where you can manage your databases.

Note: You should keep your phpMyAdmin URL and login credentials private and secure, as they can give access to your databases to anyone who knows them.

You should also be careful when using phpMyAdmin, as any changes or errors that you make on your databases may affect your web applications. You should always backup your databases before making any modifications, using the Backup feature in RunCloud.

Updating phpMyAdmin

It is always advisable to have the latest and most secure version of phpMyAdmin installed on your server. RunCloud makes it very easy for you to upgrade your installation.

Just navigate to your phpMyAdmin application in the RunCloud dashboard and click on Toolbox.

Then, simply click the Update button to ensure you have the latest version of phpMyAdmin, if applicable.

Here is a draft for the addendum section. It is written to match the existing tone of the RunCloud documentation and addresses all the specific constraints regarding server isolation and security.

Connecting and Browsing Databases

Once you have installed the phpMyAdmin web application, you can use it to manage your databases.

To connect:

  1. Launch the App: Click the URL of your phpMyAdmin web application to open the login interface.
  2. Get Credentials: In your RunCloud dashboard, navigate to Databases > Database Users. Here you can view your existing database usernames and change passwords if necessary.
  3. Log In: Enter the username and password for the specific database you wish to manage.

Managing Databases Across Multiple Servers

It is important to understand how phpMyAdmin connects to your data within the RunCloud environment:

  • Single Server, Multiple Databases: You only need one phpMyAdmin installation per server. That single instance can connect to any database hosted on that specific server, provided you log in with the correct user credentials for that database.
  • Multiple Servers: If you manage multiple servers (e.g., Server A and Server B), you must install phpMyAdmin individually on each server.

For security reasons, RunCloud configures databases to listen only on localhost. This means your databases are not exposed to the public internet and cannot accept external connections. Therefore, a phpMyAdmin instance running on Server A cannot physically connect to a database residing on Server B. You must access each server’s database via its own local phpMyAdmin installation.

If you have any other questions or need help – please feel free to get in touch with our 24/7 support team. We’re here to help!