By tstauffer on
I am new to Drupal but am taking over a web site. I need to add a new user but it is telling me that the email address is already registered. How can i look up the original user and either re-activate that account or delete it?
Comments
Administer -> User Management -> Users
If you have the appropriate permissions, you can go to Administer -> User Management -> Users. There you can manage your users: edit their accounts, block/ unblock users, and delete users.
If the problem is only that the user has forgotten his password, he can go to http://yoursite.com/user/login. Then click the tab "Request new password". A user with the permission to administer users can change another users password by editing their account.
Mark
SQL query
If not, you'll need to run perform a SQL query on the site's database:
SELECT *
FROM users
WHERE mail = 'test@drupal.org';
This will show all columns on the users table, where the registered email address is 'test@drupal.org'.
cool, how does one get to the
cool, how does one get to the SQL interface? Is there a server i can hook up to using SSMS?
When using the standard web site (drupal) it is telling me the user already exists but i can't find them
=-=
you would use the databse tool provided by the host or the environment you are working in (usually phpmyadmin).
Yes, you could use phpMyAdmin
Yes, you could use phpMyAdmin in your hosting account's cPanel. There are also software applications that you can use on your PC, such as Sequel Pro on a Mac or Oracle SQL Developer on Windows.
MySQL
Thank you to all whom replied. I was able to get in and fix the issue.