On Wednesday 14 December 2005 01:32, V S Punn wrote:

Dear Mr. Jason, Thank you for your mail. I changed the setting as per your instructions, but still the same problem. Access denied for user 'drupal'@'localhost' (using password: NO)

Please suggest.

Regards,

V S Punn

Are you sure you have this: $db_url = 'mysql://drupal:123456@localhost/drupal';

and not this: $db_url = 'mysql://drupal@localhost/drupal';

and that the information in each field is correct, as in the file's given example: $db_url = 'mysql://username:password@localhost/database';

The part of your error that says "(using password: NO)" suggests you have left out the password part of the $db_url variable.

I am attaching the file after corrections.

Regards

----- Original Message ----- From: "Jason Flatt" drupal@oadae.net To: support@drupal.org Sent: Wednesday, December 14, 2005 18:56 Subject: Re: [support] databse error

On Wednesday 14 December 2005 01:32, V S Punn wrote:

...

Dear Mr. Jason, Thank you for your mail. I changed the setting as per your instructions, but still the same problem. Access denied for user 'drupal'@'localhost' (using password: NO)

Please suggest.

Regards,

V S Punn

Are you sure you have this: $db_url = 'mysql://drupal:123456@localhost/drupal';

and not this: $db_url = 'mysql://drupal@localhost/drupal';

and that the information in each field is correct, as in the file's given example: $db_url = 'mysql://username:password@localhost/database';

The part of your error that says "(using password: NO)" suggests you have left out the password part of the $db_url variable.

-- Jason Flatt http://www.oadae.net/ jason@oadae.net -- [ Drupal support list | http://lists.drupal.org/ ]

I created the databse drupal1 from the control panel, which I have been provided along with space. I have been setting up databse for other sites, and never faced such a problem.

----- Original Message ----- From: "Jason Flatt" drupal@oadae.net To: support@drupal.org Sent: Friday, December 16, 2005 11:56 Subject: Re: [support] databse error

On Thursday 15 December 2005 21:59, V S Punn wrote:

...

I am attaching the file after corrections.

Regards

Did you setup the grants on your database, per the INSTALL.txt file?

"... GRANT ALL PRIVILEGES ON drupal.* TO nobody@localhost IDENTIFIED BY 'password';

where

'drupal' is the name of your database 'nobody@localhost' is the username of your webserver MySQL account 'password' is the password required to log in as the MySQL user ..."

-- Jason Flatt http://www.oadae.net/ jason@oadae.net -- [ Drupal support list | http://lists.drupal.org/ ]

hi VS -

So just a santiy check here: from the line in the settings file:

$db_url = 'mysql://drupal1:abc123@localhost/drupal1';

Drupal is expecting that:

1. The name of your database id 'drupal1'

2. The name of the mysql user is also 'drupal1' - does this user have grants to this database? It can get confusing when they are both named the same.

3. The password for the user 'drupal1' is 'abc123'. The grants have to have been created using this password. An example mysql statement for this would be:

grant all on drupal1.* to drupal1@localhost identified by 'abc123';

Check all these factors....

Hey, wait a minute!... this error pops up for me when the name the subdirectory in the /sites directory is incorrect... and Drupal tries to use the default settings file. It looks to me like it should be something like:

sites/raunharman.co.in/settings.php

If you have a letter wrong, it'll ignore this settings file and use the default settings file.

BTW - thanks for posting your files to help us track things down, but you'll want to change the password on the database once you have it working. I'm guessing from the 'abc123' password you were already planning on doing that!

Cheers, --Katin

I am attaching the file after corrections.

Regards

----- Original Message ----- From: "Jason Flatt" drupal@oadae.net To: support@drupal.org Sent: Wednesday, December 14, 2005 18:56 Subject: Re: [support] databse error

...

On Wednesday 14 December 2005 01:32, V S Punn wrote:

...

Dear Mr. Jason, Thank you for your mail. I changed the setting as per your instructions, but still the same problem. Access denied for user 'drupal'@'localhost' (using password: NO)

Please suggest.

Regards,

V S Punn

Are you sure you have this: $db_url = 'mysql://drupal:123456@localhost/drupal';

and not this: $db_url = 'mysql://drupal@localhost/drupal';

and that the information in each field is correct, as in the file's given example: $db_url = 'mysql://username:password@localhost/database';

The part of your error that says "(using password: NO)" suggests you have left out the password part of the $db_url variable.

-- Jason Flatt http://www.oadae.net/ jason@oadae.net -- [ Drupal support list | http://lists.drupal.org/ ]

-- [ Drupal support list | http://lists.drupal.org/ ]

Hey Jason -

Well, regardless of what has happened on previous setups, this setup isn't using the settings.php that you previously attached... that settings file has a password in the mysql setup, and the error message you are getting indicates that no password is being used to connect to mysql. Hence, a different settings.php file is being used somehow.

I'd look at the drupal/sites directory closely to see if there is something there that is pulling from a different settings file.

Cheers, --Katin

I have had no problems on several setups using the default of:

sites/default/settings.php

-- Jason Flatt http://www.oadae.net/ jason@oadae.net -- [ Drupal support list | http://lists.drupal.org/ ]

On Friday 16 December 2005 06:28, dir.dev@digitalreef.net wrote:

Hey Jason -

Well, regardless of what has happened on previous setups, this setup isn't using the settings.php that you previously attached... that settings file has a password in the mysql setup, and the error message you are getting indicates that no password is being used to connect to mysql. Hence, a different settings.php file is being used somehow.

I'd look at the drupal/sites directory closely to see if there is something there that is pulling from a different settings file.

Cheers, --Katin

Yes, I agree with you on that point, but I'm not the one with the problem. :^) So we'll wait to see if the person with the problem provides some feed back to both our comments. :^)