By ktnyc00 on

I had installed Drupal and had gotten in to the site and now I can't get back because of user name and password problems. I reinstalled drupal, even myphp and I STILL can't install drupal. I've been searching boards about changing username and password settings and I've failed miserably. I just don't get it! Can I reinstall?

Right now these are my configurations in MyPhP for mac and my drupal install window. Here is a screen grab:
http://www.razorheadsnyc.com/drupal.jpg

Any simple, clear, help would be so appreciated. I have been dying to get into drupal for 3 days now. I just want to start learning how to use it!
Thank you for any help.

⋅ Categories: Drupal 6.x

Comments

vm’s picture

vm commented

check the user table in the database for uid1, this will be the first created user. The password should be there as an MD5 hash. is it?

you can drop all tables in the database and place a new settings.php in the sites/all/default directory and reinstall drupal if you aren't looking to manually handle the database.

ktnyc00’s picture

ktnyc00 commented

This is what I have:

http://www.razorheadsnyc.com/users.jpg

ktnyc00’s picture

ktnyc00 commented

Here is the user screengrab

http://www.razorheadsnyc.com/users1.jpg

vm’s picture

vm commented

doesn't look like you have drupal installed anywhere based on the drupal database having no tables as phpmyadmin is reporting in both your screenshots.

ktnyc00’s picture

ktnyc00 commented

so what do I do? When I try to install it - it won't take my username and password?

vm’s picture

vm commented

it won't take your username and password for what?
database username and password?

did you set up a database user on your database?

ktnyc00’s picture

ktnyc00 commented

I apologize if I'm not following you.
I was instructed to create a new database in phpMyAdmin. I did and called it "drupal."
Now I go to localhost in my webrowser and the drupal installation process begins.
I get to setup a database.
I type in the name of the folder that has my drupal site download. In my case I called it drupal. I reset the settings file as instructed.

Database Name: drupal
Database Username: root or admin...? I'm not 100% sure
Database Password: I've entered anything it could have been

And I get this:
Failed to connect to your MySQL database server. MySQL reports the following message: Access denied for user 'root'@'localhost' (using password: YES).
Are you sure you have the correct username and password?
Are you sure that you have typed the correct database hostname?
Are you sure that the database server is running?
For more help, see the Installation and upgrading handbook. If you are unsure what these terms mean you should probably contact your hosting provider.

Again I'm sorry but I'm stumped?

dkeays’s picture

dkeays commented

I think you want the default MAMP username/password root/root.

The screen shot shows a blank field for the password.

ktnyc00’s picture

ktnyc00 commented

I tried:

database name: drupal
database username: root
database password: root

and nothing. Can I wipe out my MAMP and start fresh with default username and pass?
I may have messed around with it too much to know what's default??

dkeays’s picture

dkeays commented

I don't know MAMP. I assume a mistake was made or your have a corrupt database. Delete the database 'drupal' and recreate it. You shouldn't have to reinstall drupal. I have no idea about when you need to reinstall MAMP itself.

Does MAMP come with example applications? How are they accessing the database with the mysqli_connect() command?

Can you access the "drupal" database with a PHP page?

ktnyc00’s picture

ktnyc00 commented

I access the drupal database through phpMyAdmin.

When I select that database from the dropdown menu it says "no tables found in database."

I can create a new table on database drupal but I thought I'm supposed do that from my database configuration on Drupal at localhost?

I did delete it and make a new one. No luck... I think the password isn't right or something? It just makes no sense?

vm’s picture

vm commented

using google to search for information on how to change the MySQL username and password may help get the bottom of the issue.

If you want to uninstall MAMP i would assume that the process is the same as uninstalling any program on a mac.

dkeays’s picture

dkeays commented

The reason I asked about accessing the database otherwise was to:

* Narrow the problem by trying it in a simpler environment (known web app, PHP/http/mysql only, mysql server only) . This is the first step when ts'ing something that goes against instincts.

* Get the information it might take to mimic another's success. Since MAMP's default access isn't working we need to be looking into another way in.

So what do we know:
* MAMP's default access doesn't work
* PHPmyadmin's access is correct
* a bad username and password in the database is unlikely

Therefore, figuring out what PHPmyadmin is doing should be a priority.

Let's look at the phpmyadmin configuration file. On my XAMPP server (windows XP) it is:
C:\xampp\phpMyAdmin\config.inc.php

And it includes lines that tell us what is going on:
/* Authentication type and info */
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['extension'] = 'mysql';

BTW: The un/pw I mentioned were WAMP's default password I probably should have used mysql's default "root"/null. I've also seen posts online that indicate the password might be "mysql".