| | 1 | == How do I access my Drupal Database directly? == |
| | 2 | |
| | 3 | 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. |
| | 4 | |
| | 5 | phpMyAdmin is a web-based program for accessing a MySQL database. It is available on all of our servers at the address: |
| | 6 | |
| | 7 | !https://primary-server.mayfirst.org/phpmyadmin |
| | 8 | |
| | 9 | Replace "primary-server" with the name of your primary server (such as chavez, viewsic, malcolm, etc.). |
| | 10 | |
| | 11 | You will be prompted for your database username and password. |
| | 12 | |
| | 13 | This information is stored in your settings.php file. |
| | 14 | |
| | 15 | The settings.php file will be located either in: |
| | 16 | |
| | 17 | domain.org/web/sites/default/settings.php |
| | 18 | |
| | 19 | or (if your primary host is viewsic) in: |
| | 20 | |
| | 21 | domain.org/drupal/settings.php |
| | 22 | |
| | 23 | In this file, look for the line that says something like: |
| | 24 | |
| | 25 | mysql://user-name:password@localhost/database_name |
| | 26 | |
| | 27 | 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. |
