How to setup a remote MySQL database connection in PHPStorm

By Dillon Smart · · · 0 Comments

PHPStorm is packed full of features designed to make the development process for PHP developers efficient and streamlined.

Although Jetbrains have a standalone product for interacting with databases, named DataGrip, PHPStrom ships with the Database Tools and SQL plugin. This tools is powerful, integrated directly within the IDE, and provides a convinient way to intract with your databases, both locally and remotely.

How to setup a local database connection in PHPStorm

  • Open you project in PHPStorm
  • Use the keyboard shortcut to open the Search Everywhere window (Double Shift)
  • Select the Actions tab and type Database, and select the first result Database.
  • The Database tool window will open. Select the plus icon “New“.
Add a new database in PHPStorm
  • Hover over “Data Source” and select the MySQL
  • The Datasources & Drivers window will open. Here you can add the details to connect to your MySQL database
    • Enter the name of the database connection. Make this something useful so you can easily identify your database
    • In the Host field enter “localhost”
    • Select your authentication type, for this example we will select “Username & Password” and enter these details
    • In the database field, enter the name of the database. As this is local, you may leave this blank if the details you provided have root access to MySQL. In this case, you will be able to access all local database from this single connection. See How to grant full privileges to a user in MySQL.
    • You may see a Download Drivers option if you do not have the correct drivers downloaded to connect to the database. If this is the case, you will probably want to do this.
Create a Data Source in PHPStorm
  • Select Test Connection before selecting Apply to ensure your connection details are correct
Test connection to database in PHPStorm
  • After following these steps, you will now have a new Data Source added to the Database tool window in PHPStorm

How to setup a remote database connection in PHPStorm over SSH

With PHPStorm, you are also able to create remote connections to databases. In this example, we will setup a remote database connection over SSH.

Following the same steps for setting up a local database connection, in the Datasources & Drivers window, we follow some additional steps.

  • Select the SSH/SSL tab.
  • Select Use SSH Tunnel
Create an SSH tunnel in PHPStorm
  • Select the Three Dot Icon beside the dropdown field for SSH Configuration, this will open a new window
    • Enter the IP Address or hostname for your remote server in the Host field.
    • If you authenticate with Username and Password, then enter these details. If you authenticate with an SSH keypair, for Authentication Type select Key pair
    • Enter the path to your SSH private key in the Private key file field. See How to generate an SSH key.
    • You can use the Test Connection to ensure the connection works
    • Select Apply. This will close the SSH Configuration window
Configure an SSH tunnel in PHPStorm
  • In the Data Sources & Drivers windon, select the dropdown for SSH Configuration and select the new configuration just created.
  • You can use the Test Connection option to ensure your connection to the remote database works.


PHPStorm has many features to enable PHP Developers to perform their tasks in a convieniant and efficient way.

Having the ability to see your data stored in a database directly in your IDE, and execute SQL can be extremely useful.


0 Comment

Was this helpful? Leave a comment!

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Alternative ways of doing the same things in Laravel

Updated 29th March 2022

Laravel is a large framework, with contributions coming from almost 2000 developers worldwide. Over its 10 year journey, there have been additions to the framework to do the same thing, only shorter. In this post, I have highlighted some alternative ways of doing the same things in Laravel. How to get the authenticated users id

PHP Numeric Literal Separator

Updated 14th December 2023

First introduced in PHP 7.4, the Numeric Literal Separator in PHP makes large integers within your code easy to read. Naturally, we find it easier to read number which are grouped, for example, 1,650,000. Using the numeric literal separator in PHP Since PHP 7.4, we can now use numbers like this: Adding an underscore between

WordPress wp-admin redirects to HTTPS

Updated 18th May 2021

Does your WordPress wp-admin redirect to https rather than http? Below is a simple tutorial to stop this from happening. First, check the siteurl in the wp_options table within your database. Make sure the option_value is your site address with http:// not https://. If your siteurl is set as http:// the try the following. Open