Version 9 (modified by Dana, 9 years ago) (diff)


How do I access my Drupal Database directly?

Please be very cautious when making changes to your Drupal database directly. Drupal saves records in a very particular way. If you make changes to any content outside of the Drupal system, you can very easily break your Drupal installation.

phpMyAdmin is a web-based program for accessing a MySQL database. It is available on all of our servers at the address:


Replace "primary-server" with the name of your primary server (such as,,, etc.).

You will be prompted for your database username and password.

This information is stored in your settings.php file.

The settings.php file will be located in:


If you are running Drupal prior to version 7, look for the line that says something like:


In your settings.php file, your db username and password will be separated by a colon, as in the example above. Use this information to login via phpMyAdmin.

If you are running Drupal version 7 or higher, look for:

$databases = array (
  'default' => 
  array (
    'default' => 
    array (
      'database' => 'database-name',
      'username' => 'user-name',
      'password' => 'password',
      'host' => 'localhost',
      'port' => '',
      'driver' => 'mysql',
      'prefix' => '',