Drupal for DummiesDrupal Installation Problem
Hi Lynn,
Got the book from Amazon on preorder and it was delivered before Christmas! Got through the instructions on page 43 for installing on a local server and then hit a brick wall.
I'm running Mac OS 10.4.11 and I've installed MAMP. The MySQL and Apache servers are running OK. I created the new database "drupal" using phpMyAdmin tab on the MAMP Start page. I specified the database name "drupal" but I was not asked for a username or password. The MAMP Start page says that the MySQL database Host is "localhost", Port is "8889", User is "root", and Password is "root".
I then ran the Drupal installation (version 6.15) as you instructed on pages 43-44 and changed the filename default.settings.php to settings.php.
I then went back to http://localhost/drupal and reloaded the page. Clicked on Install Drupal in English. This brought up the Database configuration page. I left the default Database type selected (mysqli), entered the Database name "drupal", Database username "root", and Database Password "root", and clicked Save and Continue. The resulting page is the same Database configuration page with the Database name field empty but the username and password fields still filled in.
If I retry with the Database name and username fields filled in but leaving the password field empty I get the following error message:
****************
Failed to connect to your MySQL database server. MySQL reports the following message: Access denied for user 'root'@'localhost' (using password: NO).
* 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.
*****************
Can't figure out what I'm doing wrong. Any suggestions you have would be appreciated.
-Gene
Getting Drupal to work with MAMP
Rosali and BLT,
Thanks for your suggestions but neither solved my problem.
Tried several posts found by searching the internet but this is the only one that worked for me:
http://groups.drupal.org/node/24016
Now.....I'm off to learn Drupal!
Port Specification 8889
MAMP by default uses the port 8889 for the database server but you missed to tell Drupal about it.
On the installation page below the database information there is a further collapsed section. Open it and you will find the field to setup the correct port. Without that the communication to the database server won't take plase.
Best regards
Rosali
Help at drupal.org did not work
There are posts on the drupal.org forum that give detailed instructions for installing Drupal using MAMP on the Mac. Here is an excellent post:
http://groups.drupal.org/node/24016
Unfortunately, this did not fix my problem. One thing I noticed is that the author states, in line 22:
Open the folder /Applications/mamp/htdocs/sites/default and edit default.settings.php and add the line ini_set('memory_limit', '32M');.
This is not the same path on my local host that was created by following Lynn's instructions on page 43 of Drupal for Dummies. The path on my local machine is:
/Applications/mamp/htdocs/drupal/sites/default
Could this be the cause of the problem I'm having settng up the database for drupal? Should I try again with the CONTENTS of the drupal directory at the level of htdocs? For example:
/Applications/mamp/htdocs/sites/default
Any suggestions would be appreciated.
-Gene
MAMP problem - possible solution
Looking over the information that you have provided the thing that jumps out at me is
Failed to connect to your MySQL database server. MySQL reports the following message: Access denied for user 'root'@'localhost' (using password: NO).
Looks to me like you need to go into your
settings.php file - and provide your password --
that would be in a location similar to
drupal-site-name/sites/default/settings.php
I have done this successfully on a linux and windows machines - but I don't have a MAC.
Neat that you got an early copy over the holidays where you might have some time to experiment - no matter how frustrating that may be at times.
* Database URL format:
* $db_url = 'mysql://username:password@localhost/databasename';