wiki:faq/drupal/access-drupal-database-directly

Version 7 (modified by Jamie McClelland, 7 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:

https://primary-server/phpmyadmin

Replace "primary-server" with the name of your primary server (such as chavez.mayfirst.org, viewsic.mayfirst.org, malcolm.mayfirst.org, 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:

web/sites/default/settings.php

In this file, look for the line that says something like:

mysql://user-name:password@localhost/database_name

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.