[support] databse error

[dir.dev at digitalreef.net]

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 at 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 at oadae.net>
> To: <support at 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 at oadae.net
>> --
>> [ Drupal support list | http://lists.drupal.org/ ]
> --
> [ Drupal support list | http://lists.drupal.org/ ]