![phpstorm mysql phpstorm mysql](https://www.bounteous.com/sites/default/files/enter-credentials.png)
the syntactic correction and coloration.Explore the schema of your tables on the sidebar.You can now go to PhpStorm and test your connection again and it should work! You now have granted your user to login to using the host "127.0.0.1" GRANT ALL PRIVILEGES ON your_database.* TO identified by 'your_password'.Run the following queries (don't forget to replace yourdatabase, _youruser_ and your\password_):.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.
Phpstorm mysql windows#
Click on View -> Tool Windows -> Database.Open your project in PhpStorm and open the DataSource window: Well, spend five minutes to follow the next steps and see the pain of manipulating your data disappear! Step 1: 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?