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

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.

With RunCloud you can easily and securely manage all your web application databases, and do so much more. Why not sign up for a free trial today and see what our platform offers, we are confident you won’t look back.

Ready to get started?

Start your free trial today.

Start My 5-Days Free Trial no credit card required

15 responses to “How To Access Your Database on RunCloud (better PHPMyAdmin Alternative)”

  1. […] referring to Better Alternative to phpMyAdmin post, some might ask why did RunCloud be too restrictive? Is there any other way to easily install […]

  2. 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.

  3. Sarah says:

    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!

  4. Muhajir says:

    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?

  5. DSWONG says:

    you can get mysql password here : /etc/mysql/my.cnf

    You need to ssh from terminal, then use nano to open the file.

    Hope it helps.

  6. javier says:

    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?

  7. Ton says:

    Didn’t worked

  8. Sirius says:

    Hi, I can’t import a database, how do I do that?

  9. HeidiSQL makes it easy to import / export databases. First I make sure I create Sessions for both databases in HeidiSQL. I assume that they are on different servers. Perhaps one is on your local MySQL and you want to export it to your live database on the Internet. Then the local is your “source” and the live is your “destination”.

    Once I created both Sessions, then I connect to the “source” session. From there, you right-click on your “source” database and select “Export database as SQL”. From here you have several option as to the Output. It can be an SQL file, copy to database, or you can select other databases within the same server or on other servers by selecting a different Sessions. When you select a different Session, you will later see a list of databases where you can export your data to.

    I assume that you have created an empty database as your destination before all these. I hope this helps.

  10. d2598798 says:

    appear can’t connect to mysql server on ‘localhost’ (10061)

  11. Lamba says:

    What am I doing wrong?
    When I try to connect, I receive the following:
    OpenSSH_7.6p1, LibreSSL 2.6.2
    debug1: Reading configuration data /etc/ssh/ssh_config
    debug1: /etc/ssh/ssh_config line 48: Applying options for *
    debug1: Control socket ” none” does not exist
    debug1: Connecting to XX.XX.XXX.XXXX [XX.XX.XXX.XXXX] port 22.
    debug1: connect to address XX.XX.XXX.XXXX port 22: Connection refused
    ssh: connect to host XX.XX.XXX.XXXX port 22: Connection refused

  12. Agungw says:

    I get this error : Can’t connect to MySQL server on ‘localhost’ (10061)
    I’m looking for a solution, haven’t found it, please help,

    thanks

Leave a Reply

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