Do You Offer Direct Database Access?

Updated on July 19, 2018
233
Shares

Yes, we do offer direct database access as well as the ability to manipulate databases with tools like phpMyAdmin, HeidiSQL, Sequel Pro, and MySQL Workbench. We support secure SSH tunneling into databases stored on our Google Cloud Platform servers. Check out a few different ways you can connect below.

Connect to Database

Some of these require SSH access which is only included in our Business 1 and higher plans. Starter and Pro plans can utilize phpMyAdmin.

Connect to Database With phpMyAdmin

You can connect to your database using phpMyAdmin, which is accessible from within your MyKinsta dashboard.

WordPress phpMyAdmin access

WordPress phpMyAdmin access

Connect to Database With HeidiSQL

Below is an example of how to connect to your database directly using HeidiSQL.

Step 1

Download HeidiSQL and install it. When you first launch it you will need to create a new session file using the following information.

  • Network Type: MySQL (SSH Tunnel)
  • Hostname / IP: localhost (or 127.0.0.1)
  • User: MySQL username
  • Password: MySQL password
  • Port: 3306
  • Database: Database name
New session file HeidiSQL

New session file HeidiSQL

You can find your MySQL username, password, and database name in your MyKinsta dashboard under site info.

SSH access database

SSH access database

Step 2

You will then need to download Plink.exe and specify the location under the “Advanced” tab. Then use the following information.

  • SSH Host: Website IP Address
  • SSH Port: SSH Port
  • Username: SSH username
  • Password: SSH password
  • Local port: 3306

heidisql plink

Again, all of the information above can be obtained from your MyKinsta dashboard under site info.

Step 3

Click “Open” and it should prompt you to trust the host and add the key to your registry.

Connect to Database With Sequel Pro

Below is an example of how to connect to your database directly using Sequel Pro.

Step 1

Download Sequel Pro and install it. When you first launch it you will need to create a new connection. Click on the “SSH” tab.

Sequel Pro

Sequel Pro

Step 2

You can find your MySQL username, password, and database name in your MyKinsta dashboard under site info. Fill in following connection parameters:

  • MySQL Host: 127.0.0.1
  • Username: Database Username
  • Password: Database Password
  • Database: Database Name
  • Port: 3306
  • SSH Host: IPv4 Address
  • SSH User: SFTP Username
  • SSH Password: SFTP Password
  • SSH Port: SFTP Port

Step 3

Click “Connect.”

Connect to Database With MySQL Workbench

Step 1

Download MySQL Workbench and install it. When you first launch it you will need to create a new session file using the following information.

Step 2

Open Workbench and create a new connection. To do this, click on the Database menu → Manage Connections. Then click on the “New” button and give your connection a name.

MySQL Workbench connection

MySQL Workbench connection

Step 3

Choose Standard TCP/IP over SSH from the connection method drop-down menu.

Step 4

You can find your MySQL username, password, and database name in your MyKinsta dashboard under site info. Fill in following connection parameters:

  • SSH Hostname: IPv4 Address:SFTP Port
  • SSH Username: SFTP Username
  • SSH Password: SFTP Password
  • MySQL Hostname: localhost
  • MySQL Server Port: 3306
  • Username: Database Username
  • Password: Database Password

Then click “Close.”

Step 5 (Windows Users Only)

If you’re running Windows, you will need to update the system type under the “System Profile” tab. However, by default, these options are greyed out. To enable them, click on the “Remote Management” tab and enable “Native Windows Remote Management” temporarily.

This will enable you to change configuration options in the “System Profile” tab. Update the following:

  • System Type: Linux
  • Installation Type: Ubuntu Linux (MySQL Package)
MySQL Workbench system profile

MySQL Workbench system profile

Then under the “Remote Management” tab, switch it back to “Do not use remote management.”

Step 6

Open the connection from the list. You will probably see two popup windows: SSH Server Fingerprint Missing and Connection Warning. Simply click “Continue” on both windows.

SSH server fingerprint missing

SSH server fingerprint missing

MySQL Workbench connection warning

MySQL Workbench connection warning

You should then be able to access and manage the database.

If you get the following error: “Incompatible SSH peer (no acceptable kex algorithm)” it’s letting you know your Workbench software is out of date. However, we’ve had reports from clients about a possible bug with the “check for updates” option reporting they were already running the latest version when in fact they weren’t. The solution is to go to the download page and grab the latest version.

Was this article helpful?
No, or there was something off

Hand-picked related articles

Use WordPress?

Use WordPress?

Join 20,000+ others who get our FREE weekly newsletter with WordPress tips on how to drive more traffic and revenue to your business!

Consent

You have Successfully Subscribed!

Send this to a friend