Run the following queries (don't forget to replace yourdatabase, _youruser_ and yourpassword_):.

Log as root user to your MySQL DB: mysql -uroot.

If you're using Symfony, you can find it in the parameters.yml file.Ĭase 1 -> It works! congratulations you can now manipulate your DB from within your IDE Case 2 -> You get a wrong user/password combination error.

Click on the General tab of the configuration of your datasource.

Choose the Auth Type 'Key pair (OpenSSH)' and report the path of the IdentityFileĬlick on the apply and then click on Test Connection, you should see an error message saying you've got the wrong user/password combination Step 3: Set up the database configuration.

On the configuration window, click on the SSH/SSL tab.

Display the configuration of your ssh connection with the command vagrant ssh-config.

Click on the Database sidebar, click on new -> Datasource -> MySQL.

Click on View -> Tool Windows -> Database.

Open your project in PhpStorm and open the DataSource window: This video is a part of JetBrains PhpStorm Video Tutorials by JetBrains Technical Evangelist Maarten Balliauw. Well, spend five minutes to follow the next steps and see the pain of manipulating your data disappear! How many hours have you spent logged on your Vagrant trying to type your query, copying in a text editor, pasting, then raging because the console goes crazy and you have to start all over again? With the plugin, you can query, create and manage databases.

The Database tools and SQL plugin provides support of all the features that are available in DataGrip, the standalone database management environment for developers.

The database management functionality in PhpStorm is supported by the Database tools and SQL plugin.

If it helps, permit me to explain in full how I connect, using an identity file (also shown in the vagrant ssh-config utility).

In PHPStorm 6 to connect to a vagrant hosted VM's MariaDB/MySQL, open the Database Window (View Tool Windows Database) and add a MySQL connection using the wizard.

Phpstorm mysql