I'm trying to follow the installation instructions to get Drupal up and running on XAMPP. I get everything to work fine until localhost/drupal/install.php, where it tells me "Failed to select your database on your MySQL database server, which means the connection username and password are valid, but there is a problem accessing your data. MySQL reports the following message: Unknown database 'databasename'." I've checked it, and the database "Drupal" IS created. Can anyone help?
| Comment | File | Size | Author |
|---|---|---|---|
| #2 | settings.php.txt | 8.66 KB | mbrown3 |
Comments
Comment #1
ainigma32 commentedApparently Drupal is looking for a database called databasename while you named it Drupal ...
Assuming that you filled in the form correctly this might be a bug (if some more users report it that is)
To solve it you could try editing the /sites/default/settings.php file directly and write the correct db connection info in there. The comments in that file should probably be enough to get you on your way.
Please post back how that works out for you.
- Arie
Comment #2
mbrown3 commentedYep, that helped. The problem is that the settings.php file is just a big jumble of characters...it's not neatly laid out like other similar files (with each line containing a different bit of information and commented out). Makes it hard to find and adjust everything properly. Is there a way to get the settings.php file to display "normally"?
Comment #3
dave reidIt is actually laid out very well. Each section has a very descriptive, helpful comment and then preceeding the comment, the actual data. Albeit, the comments sometimes are pretty large (like the database section comment) but I'm not sure how this could be improved without losing it's helpfulness.
Comment #4
mbrown3 commentedNot in mine...did you check the attachment? It's one big jumble of characters. No delineation at all. The other files are very cleanly laid out...just not this one. In the attachment it looks like it has the extension .php.txt, but that's not the way it's stored on my local machine...weird. Also interesting...the instructions say to use Notepad and not Wordpad, but when I open the file in Wordpad, I get the neat, clean arrangement. In Notepad, a big jumble. Is it possible that the instructions are reversed, and that I should be using Wordpad and not Notepad?
Comment #5
dave reidAh, that's because you're probably using Windows (and notepad), which doesn't display UNIX newline characters. If you open it in a programmer-oriented style editor (like Notepad++, etc) you'll see the line breaks. I do not recommend Notepad AT ALL. :)
Comment #7
mbrown3 commentedThe exact instructions say "5. Open the file "c:\xampp\htdocs\drupal\sites\default\settings.php" in Notepad (don't use Wordpad) and modify two lines as below..."
It does not say Notepad++, etc. If Notepad is not recommended, then it should BE RECOMMENDED right in the instructions!
Comment #8
Anonymous (not verified) commented@mbrown3: Can you point me to the instructions you refer to, please?
Comment #9
tz commentedThose instructions you can find it here:
http://drupal.org/node/307956
Simple install of Drupal on XAMPP:
5. Open the file "c:\xampp\htdocs\drupal\sites\default\settings.php" in Notepad (don't use Wordpad) and modify two lines as below (but use your own password and not "twinkle"). For the second line, you will have to delete the "#" (comment mark) at the beginning of the line.
Comment #10
Anonymous (not verified) commentedThanks, tz, I've updated the page.