By regali on

HI, i'm using
Apache version 2.0.63
PHP version 5.2.6
MySQL version 5.0.51a-community
drupal 4.6.0
i followed all the installing procedures (i guess), but i still got this
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'drupal'@'localhost' (using password: YES) in /home/gajeboco/public_html/includes/database.mysql.inc on line 31
Access denied for user 'drupal'@'localhost' (using password: YES)
any help would make my day

⋅ Categories: Drupal 4.6.x

Comments

vm’s picture

vm commented

Drupal 4.6 isn't very well supported at this point.

Beyond that your version of PHP is too new for use on 4.6.0 see: http://drupal.org/requirements

PHP 5.2 or higher is only supported by Drupal 4.7.5 or higher and Drupal 5.1 or higher.

the above quoted from requirements handbook page.

Why are you choosing to use such an outdated version of core ?
I think you should reconsider the version of Drupal you are about to deploy and use a newer version specifically Drupal 5.x or Drupal 6.x depending on what contributed modules you intend to use and whether they are available for the version of Drupal that is being deployed.

rick_deputy’s picture

rick_deputy commented

Drupal supports current versioon (6.x) and one prior version(5.x)

You are 2 versions behind - i.e 4.7 -> 4.6

Rick

tanma’s picture

tanma commented

I'm also getting this problem with trying to move my site from my test server to my host server, test server specs:
Web server Apache/2.2.8
PHP 5.2.5
MySQL database 5.0.51a
Drupal 6.2

"The mysqli error was: Access denied for user 'Drupal'@'localhost' (using password: YES)."

My database is hillsPROD. The username is Drupal. Password is mypwd (not in reality lol).

$db_url = 'mysqli://Drupal:mypwd@localhost/hillsPROD';
$db_prefix = '';

Im not sure about localhost?
On my host server for some reason I seem to lack privileges in phpMyAdmin? so I can't seem to modify my DB user after creation. Still doing some investigations there but if anyone could shed some light on this that would be great!

Tan

vm’s picture

vm commented

If you are unsure about localhost as being the DB location, I'd start there as the most probable source of the error.

When you loginto phpmyadmin, at the top of the overview page may be (it is in my case) the DB server location.

tanma’s picture

tanma commented

I have at the top

Server: localhost Database: tanma_hillsPROD

Maybe the Database prefix, would you think? That was appended automatically?
EDIT: tried $db_prefix = 'tanma'; and it didn't seem to work

Also now when I try to access my website with /?q=user it comes up with the error straight away and doesn't allow me to login again. Is that normal.

tanma’s picture

tanma commented

Although it is out of my depth could it also be something to do with the php.ini?

http://drupal.org/node/66783#comment-183423

jumonjii’s picture

jumonjii commented

Depending on your host and or website control panel, you will need a prefix for your database.

Cpanel does this.

All databases and usernames have prefixes... usually your account login is your prefix.

If your username is jojo then all databases and database users will have that prefix.

So... if your database is "drupal" with "admin" being the user then it would look like this in the config file:

jojo_drupal
jojo_admin

tanma’s picture

tanma commented

Thanks all for you help, this has fixed my problem.

I had tried the $db_prefix but appending to the database and username did the trick.

Cheers
Tan