I have installed drupal on my web site www.raunharman.co.in/drupal The databse has been created (using control panel). The db details are: Dbname drupal passwd 123456
When I visit the URL www.raunharman.co.in/drupal, I get the following error: Access denied for user 'username'@'localhost' (using password: NO)
What could be the problem.
Please suggest.
Regards RAUNHARMAN TECHNOLOGIES PVT. LTD. (Solutions for the World Wide Web) #1, 1st Floor, SFS Shopping Complex, Ashok Vihar-IV, Delhi-110052, INDIA Phone: +91-11-27307325, 27306673 Cellular No.'s : 9811056604 ( M P S Punn), 9868224645 ( V S Punn) E-Mail : admin@raunharman.net Skype : raunharman Yahoo : vspunn MSN : raunharman
On Tuesday 13 December 2005 23:44, V S Punn wrote:
I have installed drupal on my web site www.raunharman.co.in/drupal The databse has been created (using control panel). The db details are: Dbname drupal passwd 123456
When I visit the URL www.raunharman.co.in/drupal, I get the following error: Access denied for user 'username'@'localhost' (using password: NO)
What could be the problem.
Please suggest.
Did you change your sites/default/settings.php file on line 81 to reflect your database setup?
It would be something like: $db_url = 'mysql://username:123456@localhost/drupal';
Also, since you have it running in a subdirectory, make sure your line 90 of the same file is correct.
It would look something like: $base_url = 'http://www.raunharman.co.in/drupal';
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 ----- Original Message ----- From: "Jason Flatt" drupal@oadae.net To: support@drupal.org Sent: Wednesday, December 14, 2005 13:49 Subject: Re: [support] databse error
On Tuesday 13 December 2005 23:44, V S Punn wrote:
I have installed drupal on my web site www.raunharman.co.in/drupal The databse has been created (using control panel). The db details are: Dbname drupal passwd 123456
When I visit the URL www.raunharman.co.in/drupal, I get the following error: Access denied for user 'username'@'localhost' (using password: NO)
What could be the problem.
Please suggest.
Did you change your sites/default/settings.php file on line 81 to reflect your database setup?
It would be something like: $db_url = 'mysql://username:123456@localhost/drupal';
Also, since you have it running in a subdirectory, make sure your line 90 of the same file is correct.
It would look something like: $base_url = 'http://www.raunharman.co.in/drupal';
-- Jason Flatt http://www.oadae.net/ jason@oadae.net -- [ Drupal support list | http://lists.drupal.org/ ]
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.
Today I am getting this error: Parse error: parse error, unexpected T_STRING in /home/httpd/vhosts/raunharman.co.in/httpdocs/drupal/sites/default/settings.php on line 102
All the settings in settings.php are as you had told.
Varinder ----- 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 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/ ]
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 ..."
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/ ]
On Friday 16 December 2005 02:51, V S Punn wrote:
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.
Sorry, I have no experience w/control panel, so I'm not even sure what to say to try. Do you have shell access also?
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/ ]
On Friday 16 December 2005 05:52, dir.dev@digitalreef.net wrote:
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
I have had no problems on several setups using the default of:
sites/default/settings.php
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/ ]
Oops - I got Jason and VS confused... sorry Jason. And thanks for helping out with the support list! :)
Meanwhile, VS - check the drupal/sites directory. Somehow the settings file you think is being used (the one you attached) isn't the one really being used.
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/ ]
-- [ 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. :^)
The clue is that it says using password no!
Look closely at the example in sites/default. For some reason you are not passing the password to Mysql. Most likely typo.
Regards
Ron
Ron Mahon Is a principal in the "InterNet Marketing Resource Center" a web site devoted to revealing the best of InterNet Marketing Secrets. A Free Super Mart of Articles, Demos, Tutorials everything you need to Succeed on the net. http://www.inmrc.com
_____
From: V S Punn [mailto:admin@raunharman.net] Sent: Wednesday, December 14, 2005 2:45 AM To: support@drupal.org Subject: [support] databse error
I have installed drupal on my web site www.raunharman.co.in/drupal
The databse has been created (using control panel). The db details are:
Dbname drupal
passwd 123456
When I visit the URL www.raunharman.co.in/drupal, I get the following error:
Access denied for user 'username'@'localhost' (using password: NO)
What could be the problem.
Please suggest.
Regards
RAUNHARMAN TECHNOLOGIES PVT. LTD. (Solutions for the World Wide Web) #1, 1st Floor, SFS Shopping Complex, Ashok Vihar-IV, Delhi-110052, INDIA Phone: +91-11-27307325, 27306673 Cellular No.'s : 9811056604 ( M P S Punn), 9868224645 ( V S Punn) E-Mail : admin@raunharman.net Skype : raunharman Yahoo : vspunn MSN : raunharman