Reset Drupal MySQL Password | Drupal 6

Reset Drupal MySQL Password | Drupal 6 | SQL

Last Updated on Friday, 20 May 2011 16:18 Written by Nicholas Dunbar

If you have access to mysql through the root user and want to just change the drupal database user this will work for you

Otherwise check out http://www.thegeekstuff.com/2009/07/how-to-reset-forgot-mysql-root-password-on-unix-linux-windows/

Step 1:

open php my admin or login to mysql using the root user.

select the mysql database and use the following cmd

UPDATE user SET password = PASSWORD('newpassword') WHERE user = 'drupal_db_username'

Step 2:

update your drupal mysql database password in drupal by finding the file

sites/default/settings.php

Specifically, look for the line:

$db_url = 'mysql://username:password@localhost/databasename';

update it with a text editor

then restart mysql and your webserver

Bookmark

Email This

Trackback(0)

Comments (0) add comment

Write comment