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/ ]