PhpStorm; MySQL autocomplete - select the database by project Follow. 487701 Created November 08, 2016 11:02. Hi, I have been using phpstorm for a few months now, but. Support for MongoDB, MySQL, PostgreSQL, and other databases. A powerful data editor that lets you modify data rows and navigate through data quickly. Coding assistance for queries similar to the one you get for your projects in WebStorm. A wide range of import and export options for your data.
It can be a bit painful to get the database connection started from your PHPStorm IDE to your MySQL database.
Webstorm Mysql Software
As a quick hint, this is where it went wrong with mine:
Intellij Database Tool
- MySQL wasn’t listening for incoming connections on the network (change directive bind-address to 0.0.0.0
in /etc/mysql/my.cnf and restart MySQL) - My database user was only allowed to connect from localhost
Edit the file /etc/mysql/my.cnf to configure MySQL to listen for incoming database connections from the network:
Intellij Community Connect To Database
Then I added a new user (dbuser) which is allowed to connect from my workstation (workstation.i2s.nl):