Talking Drupal #141 - Working with MySQL

March 29, 2017

In episode #141, we talk about getting comfortable with MySQL.




In episode #141, we talk about getting comfortable with MySQL.

  • Get familiar with the Drupal database
  • Why a SQL view is helpful
  • The command line 
  • Modules that will help
  • Tools
  • Drush import/export
drush sql-dump > \~/db.sql
drush sql-drop
drush sql-cli < \~/db.sql



Module of the Week: 

Force Password Change

This module allows administrators to force users, by role, individual user, or newly created user, to change their password on their next page load or login, and/or expire their passwords after a period of time.



Hi guys!

You missed my favorite tool for working with SQL databases, Adminer (, Database management in a single PHP file. I find that the user interface is much more intuitive than Mysql Workbench or phpmyadmin. I don't have a Mac so I can't comment on Sequel Pro.

I have a git repository with the configuration that I like for Adminer. I find it easy to git clone this in the webroot of a site, do my SQL work, then delete the adminer folder.

God bless!

Fredrick - thanks for the input.   I'm not aware of this tool.  It seems like a good tool to take with each project that does not require any additional software.  


Add new comment