By vagabond_ho on

Hi,

I'm totally new to Drupal. My vendor disappear suddenly and now I have to take over the project myself. The vendor previously gave me admin login and password to login to manage the content. The website is on live and I wish to change the admin for security purposes. Any impact after I change?

I saw some review can change via the myPHPAdmin. I just have to change that? Any other thing that I need to configure? I worry once I change it the website will be down or have problem to access the feature.

Please advice. Thanks.

⋅ Categories: Drupal 6.x

Comments

vm’s picture

vm commented

you can change it in the database user table however you have to make sure it's MD5 hashed

but if you have the login name and password

login
goto the profile
change the email address and the password from there.

scoutbaker’s picture

scoutbaker commented

If you have the actual admin account information, just log in as that account and change the password. There's no need to mess with the database directly when hyou have the current account information.

tomthumb99’s picture

tomthumb99 commented

I am close to the same as above, but no production content. Have Ubuntu, MySQL, tomcat and Drupal 6 all running fine, forgot Admin password (id: 'drupaluser'). Was hoping to avoid a re-install, passwords on admin account are likely crossed up.

First, does the default //localhost/drupal/ screen have a lockout on the admin account (drupaluser) on too many tries?

I thought that has the correct password, could file/db protection cause and invalid password. If so, please advise files the chmod on...

-- steps taken 'fix' admin password--

Initially from MySQL Admin, I went into drupal database and change 'drupaluser' password; tried that step and it broke drupal. (ie: drupal now accessible under //localhost/drupal/ screen -- no login screen).

Next, used the phpMyAdmin Web page (nice tool!) to change the 'drupaluser' password under drupal database with use of MD5 function . Then saved and the rebooted.

Now, Drupal still broken still get (drupal not accessible under //localhost/drupal/ screen ).

--- questions ----

1) Do I need to change the MySQL Drupal database with newly reset password?

2) Or does the single MySql drupal database the contain same exact IDs/pass for both MySQL and Drupal?

3) Will this SQL line command fix all problems and sync ( both drupal & Mysql)

sql> update users set pass=md5('NEWPASS') where uid = 1;

-----------

NOTE: Not looking to get stuck further here.

Thanks in advance,

TH

vm’s picture

vm commented

no there is no lockout regarding how many times someone tries to login.

I would be to change the email address of UID 1 in the database
then use the request new password feature of drupal, which will email you a new password and you can then login and alter the password manually in the profile.

tomthumb99’s picture

tomthumb99 commented

Folks,

Figured it out. I did not realize the default account was 'drupaladmin' for the //localhost/drupal login screen. I was using 'drupaluser'. I had to re-set the MySQL password in the drupal database for user 'drupaluser' back to password entered when the installed occured (ie: 'drupalpass'); now all works.

So, need to leave the MySQL accounts alone on the drupal database....

- I going with 'drupaladmin' on the //locoalhost/drupal screen, and will not touch the 'druapluser' account on MySQL

Note: I did try the re-set password option from //loclhost/drupal/, never got the e-mail. I tried for two different accounts. Any ideas what is missing on the e-mail setup? I do not setup evolution on ubuntu, do not want personal e-mail on linux