By B747 on

Hi,

I try to connect to the db on installation with details that I know are correct and Drupal says they're wrong. Wordpress, for example, installs fine.

I have PHP Version 5.2.6-1+lenny2 and MySQL 5.0.51a. I can find out more details from phpinfo() if necessary. Really don't understand what the problem could be?

Any help much appreciated.

⋅ Categories: Drupal 6.x

Comments

einsteinsboi’s picture

einsteinsboi commented

What's the exact error message that you get?

One common error when installing Drupal 6 is to rename the sites/default/default.settings.php to settings.php. You shouldn't rename that file. Instead, you should make a copy of it and name the copy settings.php. Drupal needs these two files to be sitting in that folder for the install to complete successfully.

B747’s picture

B747 commented 
Failed to connect to your MySQL database server. MySQL reports the following message: Access denied for user 'c16_drupal'@'localhost' (using password: YES).
Are you sure you have the correct username and password?
Are you sure that you have typed the correct database hostname?
Are you sure that the database server is running?
For more help, see the Installation and upgrading handbook. If you are unsure what these terms mean you should probably contact your hosting provider.

I had in fact renamed my default.settings.php as settings.php. However, even after extracting the original default.settings.php on my hard drive, uploading it, renaming the local file settings.php and uploading that and running the installer again, it still doesn't work!

Thanks for your help so far - any further ideas?

einsteinsboi’s picture

einsteinsboi commented

OK, this is going to sound like a really silly question, but you're sure you've actually created a database for Drupal to install to and you're putting in the right name?
Are you running as root user or do you have a specific user created for this new database? And if you do have a specific user, have you added that user to the database and given all privileges?

My recommendation actually at this point is to delete your database, remove the files, create a new database and start again just to be sure you're doing a clean install and that Drupal hadn't written anything to the config files the first time you tried.

Honestly though it does sound like a simple database name/password issue.

B747’s picture

B747 commented

There seems to a be a major problem with my MySQL set-up which I have no idea how to fix but will have to try. Meanwhile, I have installed Drupal elsewhere and hope to migrate when I can get the databases working on my primary server.

Thanks for your help!

donwinchell’s picture

donwinchell commented

If you are on a third party hosting company there can be a prefix in front of the actual database name such as:
hostingcompany_database name. you may have to include the full name in drupal as the name of the database. so let's say you host with "hostco" and your database name is "myfirstdrupal". it is possible that the database name in drupal setup will need to be hostco_myfirstdrupal rather than simply myfirstdrupal

peter-boeren’s picture

peter-boeren commented

Maybe you can follow these steps: http://webdesign.about.com/od/drupal/ss/install_drupal.htm

Slide 4 is about mysql. But you can also use phpmyadmin to create a user with privileges (and database with the same name).

donwinchell’s picture

donwinchell commented

dear all how tried to help.
thanks
I had to leave this to build a project, this is also a response to another thread,
Thank you all for your suggestions.
I just wanted to follow-up quickly now but will eventually share much of what we have learned.
we did not go the CCK route as the kind of "duplicate" or "shadow" system that implied seemed daunting and like it would add a lot of complexity.

we have managed to create a fairly feature rich and robust data management system using Drupal that allows for importing data from card scanners, outlook address books, php list and exporting back to outlook. It also interacts with MailChimp via api and manages unlimited groups. I hope to post a demo version soon along with a snap-shot of hours that went into it.

too busy right now, but more to come. thanks to all

Don