Connecting to your Database

Once you have created a database in SpinupWP you can manage the database in two ways: using the command line (CLI) or using a desktop app.

Using the CLI

To manage the database using the command line first you need to SSH to your server:

ssh user@123.456.78.91

Once you are logged into your server you can manage databases using the mysql command. To log in using mysql run:

mysql -u dbuser -p

You will be prompted for your database user’s password. You can now manage your databases.

Using an App

The most convenient way to access and manage your database is using a desktop app via SSH. We recommend TablePlus, which supports macOS, Windows and Linux. TablePlus offers a free trial which is limited to 2 opened tabs and 2 opened windows at a time, but you can upgrade to a paid license to unlock all functionality.

With TablePlus, you enter your SSH connection credentials (the same credentials you use to SSH into your server) AND your database connection info.

TablePlus connection settings

  • The MySQL Host will always be 127.0.0.1.
  • The MySQL Port will always be 3306.
  • The database Username and Password will be what you entered when you created your site.
  • The SSH Host is the IP address of your server.
  • The SSH User is a sudo user or site user from your server.
  • If the SSH user is using key based authentication, select Use SSH key. Otherwise, enter your SSH password.
  • Leave the rest of the settings as their defaults.

Note that you can use the “root” database login and password (specified when you spun up your server) if you want to access all the databases on your server with one login.

phpMyAdmin

Although you’re free to manually install phpMyAdmin yourself, we do not recommend it. It is far less secure than accessing your database using a remote client app via SSH as described above.

Start Your 7-Day Free Trial

Start your SpinupWP journey today and spin up your first server within minutes.

Subscribe to get the latest news, updates and optimizations in performance and security.

Thanks for subscribing 👍

To receive awesome stuff, you'll need to head to your inbox and click on the verification link we sent you.
Make sure to check your "spam" folder or your "promotions" tab (if you have Gmail).
If you're still having trouble, then message us at sudo@spinupwp.com.

You are already logged in

It looks like you are already logged in to SpinupWP.

Please log out of this account to continue.

Registration Successful

Thanks for registering for a new
SpinupWP account.

Before getting started, could you verify your email address by clicking on the link we just emailed to you?

SpinupWP

Free Trial

Start Your 7-Day Free Trial

No credit card required. All features included.

By signing up to SpinupWP, you agree to our Terms and Conditions.
For privacy related information, view our Privacy Policy.