In the Lando configuration file (either the project-wide.

Step 1 - Allow Lando to Receive Incoming Database Connectionsīy default, Lando does not allow anything but the Lando app to connect to the database server, so we need to tell Lando that it’s OK for PHPStorm to connect. Be sure you’re not working directly with a live/production database! We suggest using the database tool on a local copy of the database that can be restored if needed. Copy and paste the following activation code and click OK (currently valid until January 2021, this activation code will be updated continuously) The following activation code is to avoid modifying the hosts file. Obligatory warning: After you connect to the database, you'll have access to modify or delete data, tables, or the entire database. If you’re using another local environment like DrupalVM or DDEV, you can use the following steps as a guide for how you can connect these other environments. In this guide, we'll show you how to connect to your local Lando environment’s Drupal database from within PHPStorm. The database can provide insight into how your data is flowing throughout the system, which can help when debugging errors or when working with a new module that modifies data before saving. Given the Drupal database is where all content and active configuration are stored, developers should feel comfortable leveraging the database as a research and diagnostic tool when developing solutions or debugging problems. Many developers only interface with the database via Drush commands, performing database backups, or moving content from the server to their local machine. In addition to its outstanding ability to help any PHP developer's productivity, it offers several Drupal-specific time-saving tools-like the ability to handle code completion for hook declarations and applying Drupal coding standards.Īmong the many tabs that border the PHPStorm IDE window is one that offers access to one of the hardest-working components of the Drupal ecosystem.the database! PHPStorm is one of our favorite Integrated Development Environments (IDE) for building Drupal sites.

Phpstorm mysql