How To Access Your Database on RunCloud (better PHPMyAdmin Alternative)

Some may wonder how do you access your database in RunCloud. We have been getting inquiries on how to install PHPMyAdmin, or where it is installed.

Well, there is none. And we don’t recommend that you install them.

You can read the full tutorial below, but first let me explain the main concept on how to go about with this.

To access your database, the MariaDB that we installed in your server, first you would need to establish a secure SSH connection to your server. This is where you use the terminal (on Mac and Linux) or Putty (on Windows). And then we can use any other MySQL client software to utilise the SSH connection to connect MariaDB. It will be like connecting to MariaDB from “inside” the same server.

This is what we call “tunneling”.

In my years on server administration and web development, I don’t quite like PHPMyAdmin because it is web-based. I am on a Windows computer so I use a software called HeidiSQL. If you are on Mac, you can use Sequel Pro. Both are free software.

And the good thing is that it comes built in with tunneling option, so you don’t have to establish your own SSH tunnel connection using Putty or the Terminal.

In this tutorial we will be accessing the database as root, meaning you have full access to the database. RunCloud notifies you of your MariaDB Root password at the end of the server connection process. Do you remember this screen? I hope you kept the details safe, and now we need to use them back again.

When we have this, we can launch our HeidiSQL. What you need to do is just enter the details for

  1. MySQL connection settings (use MYSQL ROOT Password)
  2. SSH Tunnel settings (use runcloud password)

This is the interface for creating a new database connection in Heidi SQL.

Make sure you select the “MySQL (SSH tunnel)” for Network type.

Then, enter your username (root) and password for MySQL. Make sure you enter “127.0.0.1” for host. And then, enter your password.

If you look at the top, you will see there is a tab labelled “SSH Tunnel”. If you don’t see it, make sure you selected “MySQL (SSH tunnel)” for your Network type. Click on that tab so we can set the SSH tunnel settings.

This is where you need your runcloud password. Enter your server IP address, runcloud for username and the password that was given to you during server connection process.

When the connection setup is complete, you can just double click on your new connection to connect to your database server. If all is good, you should see an interface that looks more or less like this.

You can start to explore your database now, and do the normal things that you do on PHPMyAdmin, only faster, more intuitive and easier. Just be careful because you are accessing real data in the database now. Be aware of the changes that you are making like adding new records, remove data, updating data and the rests.

All the best.

Share This On
Share on facebook
Share on twitter
Share on linkedin
Share on reddit

16 thoughts on “How To Access Your Database on RunCloud (better PHPMyAdmin Alternative)”

  1. It would help if you could put a note somewhere instructing your customers to save the master password. I never do and I don’t think anyone else does either. This looks like a good way of doing it. I will stick to adminer for now.

  2. Thank you for this. I’ve always used phpmyadmin but of course, it’s a major security risk. Never knew this was possible. Just switched some of our projects to RunCloud!

  3. I still cant connect using heidiSQL, this article wont help at all. “Its work this way, i dont care what you use”
    Please make another mechanism/article where we already forgot the root password, how do i connect now?

  4. what about creating a temporary(or not) app, install phpmyadmin there and enable SSL, then that should be secure as well.

    What do you think?

  5. Is there a way for a user to have access only on his database? Login with his database credentials and access his database. This can be done using phpMySQL, but is it possible using Heidi SQL?

Leave a Comment

Your email address will not be published. Required fields are marked *

You May Also Like

Scroll to Top