MySQL Databases for Developers
This section contains selected resources and guides for dealing with the MySQL databases that are integral to every Drupal website.
MySQL
Creating a MySQL Database
Creating a new MySQL database for a site hosted on OIT Web Hosting can be a little confusing. Below are the steps for getting a database set up and configured properly via the Web Hosting Plesk control panel, as well as generic steps for creating a new database on any MySQL instance that has phpMyAdmin installed.
Listing Enabled Modules Using phpMyAdmin
Below is SQL code that prints out SQL statements that you can copy and paste back into phpMyAdmin (or any MySQL management tool that can connect to your Drupal database). These statements will help you get a list of enabled modules, when you need to check multiple Drupal 6 or 7 databases at one time.
With thanks to Aaron Brown on DBA.stackexchange for the basic code.
Listing Enabled Modules Using a bash Script
A shell script that prints out a list of enabled modules in all accessible databases, designed for ssh use when you need to check multiple Drupal 6 or 7 databases at one time.
Editor's Note: A similar concept would work just as well for Drupal 8, but the database table names and structures have changed in Drupal 8, so you would need to adjust the script accordingly. Also, be aware that this script will not work on any Drupal instance where you have used a custom table prefix for all of your Drupal site tables.
MySQL Database Connection Tools
You can view any MySQL database on an OIT Web Hosting website using many different GUI based applications. Below are a few implementations that have been used by members of our community: