Last updated March 23, 2014. Created by dwees on May 30, 2006.
Edited by mgifford, tea.time, danbohea, Sheldon Rampton. Log in to edit this page.

MAMP creates a local server environment on Mac OS X by installing PHP, MySQL, and Apache right out of the box. This will make Drupal much easier to install because the components don't have to be installed separately. This page is to be used in conjunction with the installation instructions for Drupal on Mac OS X.

Also you may want to check out this video in the Videocasts section of the handbook: Installing a Local Web Server on Mac OS X.

Download MAMP

(This will install Apache, MySQL, and PHP in one step.)
Find the latest version here: http://www.mamp.info/
Download and proceed through the installer to install MAMP. Open MAMP and click "start servers," then "Open start page."

Download Drupal

Find the latest Drupal release here: http://drupal.org/.

Move the directory containing the Drupal files into the MAMP htdocs directory:

mv drupal-x.x.x/* drupal-x.x.x/.htaccess /Applications/MAMP/htdocs/yourdrupaldir

where yourdrupaldir is whatever you want the directory to be called.

Note: if you use Finder you may miss moving the .htaccess file which is necessary for clean URLs to work. It is generally best to download and unzip Drupal directly in the document root (default is htdocs) so you don't miss the .htaccess.

Create the Drupal database

To create a database for Drupal

  1. Go to the MAMP start page
  2. Click "phpMyAdmin"
  3. On the next page click "Databases"
  4. On the "Databases" page enter a name for your Drupal database in the "Create new database" field at the bottom of the page
  5. Select "utf8_general_ci" under the "Collation" drop-down (must be utf8!)
  6. Click "Create"
  7. Next you must create a user name with the privileges Drupal requires to use the new database
  8. Jump to your new database by clicking its name in the left sidebar and then click the "Privileges" tab.
  9. On the next page click "Add user".
  10. Fill out the "Login Information" form, making sure to change the "Host" field to "Local" and not leave it as "Any host" (for some reason Drupal will not be able to connect to your local database if you select "Any host")
  11. Leave the "None" radio button selected under the "Database for user" section, and under the "Global privileges" section leave everything unchecked
  12. Click "Add user"
  13. Go back to the main phpMyAdmin home page by clicking the Home icon in the left sidebar.
  14. Click the "Users" tab and edit the user that you just created.
  15. On the next page scroll down to the "Database-specific privileges" section and select the new Drupal database you created from the dropdown and then click "Go".
  16. Check the SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX and ALTER checkboxes and then click "Go".

You can also use a GUI such as Sequel Pro, just remember to use this as your Socket:

/Applications/MAMP/tmp/mysql/mysql.sock

Changing your password

The default username/password for your MySQL install is now root/root! For security purposes, it's always best to change this. If you're connected to the internet, this is a must.

When you are changing the default user/password from root/root, you need to do two things. Only the first is documented in the MAMP start page FAQ, but if you don't do the second then you get an error message when you try to access anything from the MAMP start page.

  1. Use command line to change the password (as documented in the MAMP start page FAQ)

    Open the terminal and type the following:
    /Applications/MAMP/Library/bin/mysqladmin -u root -p password [NEWPASSWORD]

    It will ask for the current password after you hit enter. Once you have entered that, the MySQL password is changed.

  2. Open a text editor and change the password in the four following files:
    • /Applications/MAMP/bin/phpMyAdmin-X.X.X/config.inc.php

      Find the line that reads...
      $cfg['Servers'][$i]['password']      = 'root';
      ...and change the value 'root' to your new password, retaining the quotes.

    • /Applications/MAMP/bin/mamp/index.php

      Find the line that reads...
      $link = @mysql_connect(':/Applications/MAMP/tmp/mysql/mysql.sock', 'root', 'root');
      ...and change the last parameter to your new password.

    • /Applications/MAMP/bin/stopMysql.sh

      Find -proot and replace just the root part with your new password. Note that it's important not to have a space between -p and the password itself. (If you don't change this one you can have zombie mysqld's running after you thought you stopped the server.)

    • /Applications/MAMP/bin/checkMysql.sh

      As above, replace root in -proot with your new password. (If you see an error pop up when you run the MAMP app that says "Error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect", this should fix it.)

Or in Mamp Pro you can change the MySQL password under the "MySQL" tab.

Optional: Adjust PHP's memory limit for scripts

By default, MAMP has the memory limit that a script can use set at 8MB, which is the PHP default. Looking at PHP's php.ini-recommended file, this memory limit is normally set at 128MB. To adjust this amount, open the php.ini file in a text editor and change the following line (approximately on line 232):

memory_limit = 8M      ; Maximum amount of memory a script may consume (8MB)

PHP.ini file locations:

  • /Applications/MAMP/conf/php4/php.ini
  • /Applications/MAMP/conf/php5/php.ini

In MAMP PRO, don't alter the file directly since it will be recreated at each server start. Please edit the appropriate template (menu File > Edit template > ...) instead.

MySQL issues

Even with larger PHP memory limits you can get timeout errors trying to import large Drupal databases into MySQL. These issues are discussed at length elsewhere with regards to the cache and views cache. Generally the solution is to empty the Drupal cache before importing/exporting databases to/from MySQL.

You may also need to adjust MAMP's memory settings for MySQL. For example, if you get an error message that says, "General error: 2006 MySQL server has gone away," it probably means that you need to increase MySQL's max_allowed_packet setting. To change this setting, edit file /Applications/MAMP/bin/startMysql.sh by appending --max_allowed_packet=100M at the end before the & character.

To adjust MAMP Pro's memory settings navigate to:

File > Edit template > MySQL my.cnf

In the text file that opens, change the value for 'max_allowed_packet' to 100M. Note you can set this in MAMP by adding your own my.cnf file manually.

Adding mysqldump and other libraries to $PATH

In order to make use of mysqldump and other libraries that ship with MAMP you'll likely want to add the location of these libraries to your $PATH (especially if you want to use some of the SQL functions of Drush). Tap the following line into Terminal and hit Return:

export PATH=/Applications/MAMP/Library/bin/:$PATH

Start configuring Drupal!

  • Navigate to http://localhost:8888/yourdrupaldir/install.php
  • Fill in the installation fields using the information provided on the MAMP start page and the database you created in step 4 as well as the username you specified in step 10.
  • Continue filling out the remaining fields during the installation.
  • Refer to the INSTALL.txt, in the Drupal Root directory, for additional help.

NOTE!! If you changed your MySQL username and password, at any time post-installation, you will need to modify that in your local Drupal settings.php file as well.

Temporary Files Note:

By default the File System settings (admin/config/media/file-system) will place the temporary files directory inside /Applications/MAMP/tmp/php which should be changed to something like files/tmp or sites/files/tmp to avoid later confusion.

Clean up your Localhost URL

If you would like to shorten your URL from "http://localhost:8888" to "http://localhost" follow these instructions:

  • Open the MAMP application
  • Click on "Preferences" and then "Ports"
  • Change the Apache Port to 80 (the standard web server port)

In MAMP PRO, change the port of apache to 80 and click on apply.

Looking for support? Visit the Drupal.org forums, or join #drupal-support in IRC.

Comments

Here's a link to MAMP forums if you need to know where to change the passwords listed in #2 of Changing Passwords on this page:
http://forum.mamp.info/viewtopic.php?f=2&t=1719

By default, Mamp's MySQL configuration doesn't allot adequate memory to caches and related performance measures. I've found that using the right configuration file can make a big difference in localhost performance.

To start, take a look at some potential configuration files at /Applications/MAMP/Library/share/mysql

For example:
my-small.cnf
my-medium.cnf
my-large.cnf

etc.

Read through the information inside these configuration files to see what works best with your system. I've used my-medium.cnf with good results.

Copy and rename your desired configuration file to my.cnf and then move it to /Applications/MAMP/db/mysql

Restart MAMP for the changes to take effect.

The place for the my.cnf is not anymore /Applications/MAMP/db/mysql but /Applications/MAMP/Library/

It was a good start but not enough. I work on a project with 1Go DB an MAMP is definitely to slow. I tried to install with macports and is just day and night! I made a small howto http://listentothis.net/mac/forget-mamp-install-apache-php5-mysql5-with-...

Hopefully this will save some other command-line-newbie some grief:

To change MySQL's root password -- which is root by default -- here's what you need to enter at the command line, where [NEWPASSWORD] is the password you'd like, and [OLDPASSWORD] is the current password:

$ /Applications/MAMP/Library/bin/mysqladmin -u root -p password [NEWPASSWORD]
Enter password: [OLDPASSWORD]

Ruthie BenDor, web designer & developer
http://www.unruthless.com/

I suggest that someone rewrite the whole instructions to make this easy. It was yet another unnecessary half hour wasted due to lack of clarity and reading backwards. It seems all of Drupal writing states, "Do this first, but before that you should read x." So you backpedal to x (with a new browser window so as not to lose your place) and there it says, "Before you do this, you should read y."
I'm aware that this is all volunteer work, that one mustn't look a gift horse in the mouth and that helpful hints come after the fact and so is always addenda, upon which gets put more addenda, so you end up doing everything in reverse.
I wish I knew how to be of help with this sloppy situation. Someone needs to rewrite the most basic installation instructions, –twice. Once for Windows and once for Mac and incorporate all of the comments added later. I see this hasn't been done in some years in this lesson's case.

Instructors often take for granted students know all the "computer stuff" the teacher knows except for the exact lesson.
But it's common sense that if you're teaching a purely green newbie-type lesson (like changing permissions?) that you must not assume the reader is proficient in or maybe ever looked at "Terminal" before, right?

It took me awhile to realize that by "Terminal" was meant a Mac utility application. Then it's totally unintuitive what is meant to be written in where. [oldpassword] and [newpassword] was a big help Unruthless.

It should also be mentioned for newbies: First off, you won't see the typing as you enter [oldpassword]. Not even dots.
And don't expect to get a pat on the back from Terminal when you have succeeded in changing it.
If you've done it successfully, all you'll get is another line of type showing the name you gave your Mac's "home" followed by $. This indicates it has processed the command OK and is ready for another.

Mike Storer

It's also worth noting that for Terminal don't include the brackets [] in the pw. That's what I did.. newbie mistake. :-)

Michelle Blum
Drupal 6.10
--
Portland Marketing & Web Development

Changing your password is easy in Mamp PRO, just click the interface button change password, done...no need for command line that's old school.

You can actually change the location of the htdocs in the preferences panel under apache. I've set mine to Sites and it works well. It also mean that if I delete the mamp folder all my sites are still there!

As mentioned Sequel Pro is free and superb for editing databases.

VirtualHostX is great for setting up virtual hosts. It's as simple as naming your virtual host and showing it the directory and clicking add. Saves messing around changing the virtual hosts yourself.

I've also created a couple of scripts that I've saved as apps that I can quickly start through quicksilver. The scripts start and stop both my apache and mysql servers. This is useful if, like me, your on port 80 and don't want to enter your password every time. It means I don't even need to start mamp, but can run everything via quicksilver and my keyboard! I also don't like the servers running all the time, so this makes it very simple.

With an install of MAMP on the Mac, I found that there are four other places (besides the three files mentioned above) that need a change of password. They are:

/Applications/MAMP/bin/checkMysql.sh
/Applications/MAMP/bin/quickCheckMysqlUpgrade.sh
/Applications/MAMP/bin/repairMysql.sh
/Applications/MAMP/bin/upgradeMysql.sh

This should prevent some annoying error message popups when you start MAMP.

S. Simmerman

I have been using Linux for so long to develop with Drupal, I had forgotten about this issue with MAMP set-up. After following the instructions above, I was still presented with

/Applications/MAMP/Library/bin/mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect

even though I could still make connections to the server with my new credentials. Updating the files you mention here with the new info worked to get rid of the message - thanks!

dood:~ john$ /Applications/MAMP/Library/bin/mysqladmin -u root -p password
Enter password:
/Applications/MAMP/Library/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'
dood:~ john$

In a reply above, it says that this is because the settings.php file needs to be changed and that it should be in the drupal root directory, not the sites/default directory.

I can't find a settings.php file on my system.

John

I had the same problem. The instructions above say that your default username is "root" AND your default password is "root", so keep that mind.

I used this command:

/Applications/MAMP/Library/bin/mysqladmin -u root -p password NEWPASSWORD

where you should change NEWPASSWORD to the password you want to change root to (this is in cleartext, so it's probably not super safe).

The command line will then prompt you for a password. Remember, type in root as your password (it's the system default).

OK. After dropping this attempt A YEAR AGO. I am back at it.

I, too, got the terminal to accept the NEWPASSWORD but then when I had to confirm with the OLDPASSWORD on the next line I got the failure message

/Applications/MAMP/Library/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'

I went to my new unsuccessful (due to this mysql business) Drupal install on my localhost, found the line on my settings.php and was wondering if the mysql u-user and p-password is suposed to be the same as line 92 of the settings.php, which is about the $db_url, but which includes mysql in its path.

I made this to match exactly the database and password on my webhosting. Should I change my MAMP username too? How do I do that? Isn't the db username different?

And what if you've lost your original password? (It's been a year, many ditched efforts, and two moves later)
Can I just re-install MAMP and will it over-write whatever was there before?

SO FRUSTRATING. I can build a whole website, but I can't get my locahost working on my own computer. Makes me want to chuck my Mac...

Last night I tried the installation. I had a problem similar to the one that you are referring to.

'Access denied for user 'root'@'localhost' (using password: YES)

After become frustrated with this and not finding any help around, I just deleted the complete MAMP file and drupal file. I also made sure that I also deleted any related mysql files. After that I downloaded the drupal and MAMP again and installed them. I was able to have a fresh set up. I am not a computer savvy person, so this is my kind of barbaric solution. Hope it helps.

I managed just fine one I realized that one, it was not showing my password or asterisks as I typed, and two, the old password is root, not root/root.

By default, PHP does not display error messages in the browser (MAMP 1.8.4). They are logged in /Applications/MAMP/logs/php_error.log

In order to display error messages in the browser, you need to modify /Applications/MAMP/conf/php[5|4]/php.ini. Change display_errors = Off to display_errors = On. This is OK for a local development environment. It is discouraged though for production environments.

You might also want to play with the value of error_reporting. When set to E_ALL, all messages will be displayed. If desirable, this can be changed to display a subset of messages.

To display error stack in addition to the error message, uncomment zend_extension in the [xdebug] section. Again, this is OK only for local development environment.

You need to restart MAMP servers in order for the above changes to take effect.

I followed the steps in this "how to" get started with Drupal on my local mac, but when I get to the install part of designating the database, this is the message I get:

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: Access denied for user 'yachin'@'localhost' to database '/Applications/MAMP/db/mysql/blackbox.db'.

* Are you sure you have the correct database name?
* Are you sure the database exists?
* Are you sure the username has permission to access the database?

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 have checked each step several times, deleted and recreated the database steps, etc. I did check in my Finder and do not see an actual database file with the name I designate, although there is a directory created with that name under the db/mysql folder. I'm totally new at this, so have no clue as to what to do next.

Not sure if you've solved this problem or not but if you just want to learn about Drupal without trying to learn about the complexities of configuring Apache, PHP and MySQL head on over to: http://acquia.com/downloads/mac-installer and check out the Acquia Stack Installer for MAC OS X. It's a free packaged installer that includes all the components you need to create a Drupal website on your local system in a few mouse clicks.

I tried that Acquia Stack Installer and quickly uninstalled it lol Mamp Pro is way better.

Hello,
I was using i18n module, and I got an error:

user error: Access denied for user: 'user@host' to database 'database'
query: LOCK TABLES sequences WRITE in [path]/database.mysql.inc on line xx

I just Granted Lock tables permission and everything worked fine.

More information:
http://drupal.org/node/17241

Visit my drupal site at: www.viajesdesorganizados.com (Disorganized Trips!)

One minor change: When you write, "Replace the -proot with your password...", what it should say for noobs like me is "Replace the -proot with -p<yourpass> where <yourpass> is the new password."
I figured this was the case, but it never hurts to be explicit. In any case, the instructions here are great--thanks for the help.

Yes, this is important but maybe not obvious for users new to mysql commands - there must be no space between the -p option and the password.

I followed the instructions (with the latest versions of Drupal and MAMP at 12/17/2011; MAMP 2.0.5 and Drupal 7.10) and they worked perfectly. the suggested change of:

"Replace the -proot with your password...", what it should say for noobs like me is "Replace the -proot with -p where is the new password."

is STRONGLY seconded. I'd set up Drupal like this before (I've since DBAN'd my HD) and had someone at my DUG to help walk me through it. I'd also read all the comments before I used the instructions. So, I knew what to do there. But someone new to Drupal and MAMP may not.

Also, this change would keep the instructions consistent with the format of the previous two steps, where the reader is told specifically what to change when updating their password. After reading through instructions on how to change the first 2 of the 3 files mentioned, I'd think someone would expect similar instruction for the 3rd file.

But overall, GREAT instructions.

With Mamp Pro they have it setup where you can secure your localhost so you don't need to set a password, just use root root, it's easier that way. Nobody will be able to access it except you.

I had a ton of bugs when I was working on localhost sites and they seemed to go away once I went live. All of these bugs went away once I changed the php version from php 5.3.x to php 5.2.x. Small change, big difference.

newbie here.

see subject. On a Mac OS10.6.3 downloaded the alpha drupal 7. Followed directions exactly for MAMP and phpAdmin. I've tried adding " /Applications/MAMP/htdocs/ " between " localhost:8888/ " and " drupalsite/ " to troubleshoot, but no go.

why the 404?

N

N

I removed the actual folders to just install.php and it worked.

N

Thanks to all in advance..

I have installed MAMP and loaded drupal to the correct folder. i imported the data base using phpMyadmin. when i go to http://localhost , i get 'the site is of line. refer to settings.php. What and where should i point to in the settings.php file?

djg

If your sites are not stored in the htdocs directory provided by MAMP, then you will have to add a definition for that directory to your httpd.conf file (found in MAMP/conf/apache)

Options All
AllowOverride All
Order allow,deny
Allow from all

If you do not do this, then the default setting of AllowOverride None will apply and drupal will not be able to use the .htaccess files required to make the site work. You will get errors talking about "requested URL not found" for any page except the homepage of the site.

I usually put this directly above my definitions for the virtual hosts.

Michael Thorne

It took me a good while to figure this one out:

when you change the root password for the MySQL, you have to go to the Mac Terminal by going to the Applications folder then to the Utilities folder and then click Terminal.

Applications>Utilities>Terminal

Next you paste /Applications/MAMP/Library/bin/mysqladmin -u root -p password [NEWPASSWORD] into the window and in place of [NEWPASSWORD] (including the brackets [ ] ) you type your new password. So it may look something like this:

/Applications/MAMP/Library/bin/mysqladmin -u root -p password froggies

Then hit enter on your keyboard and it will ask you for your old password which should be the word [root] (not including the brackets [ ]) ofcourse.

hope that helped anyone.

-Nabi

Why does my drupal installation breaks as soon as I change mysqlamin password?

If I leave it as root, it sets up fine, but if I follow above mentioned instructions I cannot connect anymore to database or phpmyadmin.
I see from comments that this issue is here forever and nobody seems to be able to come up with real solution. And by the way, changing password in all those .sh files doesn't change a damn thing. I still cannot connect to database - I get access denied message in browser as well as in terminal./

My questions:

- Is this MAMP, Drupal or Mac OS X specific issue?
- Are there other alternatives to MAMP? ( setting up a simple local environment is not supposed to be such a difficult thing)
- Does anybody know how to fix this issue? I'll have to change the password at some point! ( I don't know anything about scripting voodoo so I need some advice for noob)

I will be thankful for any good tip.

I get the same problem. When I follow the above instructions to change passwords (including the 3 files after the terminal changed pw), I cannot connect to mysql. Something's wrong. PLEASE FIX THE INSTRUCTIONS.

I am on a Mac XEON tower with OSX10.5.8

When I first launch MAMP, I get a web page showing that says: "Error: Could not connect to MySQL server!"
Then I get a message from MAMP saying:
"Checking MySQL databases failed"

/Applications/MAMP/Library/bin/mysqlcheck: Got error: 1045: Access denied for user
'root'@'localhost' (using password: YES) when trying to connect"

Apparently, the instructions for changing the root password have left out somewhere that needs to be changed. I have no idea what the "YES" password is. I searched thru some of the config files and couldn't find anything.

I've attempted this twice. Now I'll just use root as a password, but I hope for new instructions very soon, as I have a deadline to deploy my site. But, perhaps this only applies to local deployments???

EarthEdNet

I'm having the same problem - I don't understand #2 in the instructions - what am I supposed to open in a text editor? Which document? These instructions are confusing and have led me into a frustrating situation with my MAMP installation, which worked fine until I came to this page and was convinced I had to change my password for a successful installation.

Check the comments "Other Places to Change Password" and "Excellent Instructions" for answers.

The password instructions above is not necessary since this is inside the MAMP app itself very simply. Click on mysql and change password, done.

I recommend Mamp Pro everything is done via the app no need to open terminal.

I also keep my username/password as root/root for local hosting, keep it simple. I mean why not it's local nobody can access it.

Be sure to point your browser at http://localhost:8888 or http://localhost:8888/drupalsite so it can access the mysql server properly.

If you have a Mac and you want to set up Drupal locally using MAMP you would think that the instructions would be clear and that all of us would have to perform the same tasks to get Drupal up and running. These instructions are not for the novice and the comments that follow provide some instruction and correction but it's hard to know who to trust. I tried to set this up twice today, after the first time I completely got rid of MAMP and any shred of Drupal that I had on my machine and started fresh. Still many problems and a waisted day. My suggestion, even Mac owners already have Apache and MySQL available, is it to go http://acquia.com/downloads/mac-installer and install the Acquia Drupal Stack Installer. After doing this I had Drupal on my machine and the Apache and MySQL servers up and running and I was ready to start building a web site locally. I have been using MAMP in a class at school so it's not like I'm not somewhat familiar with it. I think MAMP needs to write some instructions and quit pointing users of their product to Drupal. If you are not into MAMP, just trying to get Drupal configured on it might turn you off completely.

EDIT: Drupal 7 installs into MAMP very easily.

B. Womack, Drupal Newbie

During install process page keeps reverting back to input page requesting the data again?? I input database name, username and password and page comes page requesting the same info.

I have exactly the SAME problem ... looked for hoiurs on the internet to find a solution ... NO GO !

Anybody who knows the answer, please stand up ;-)

Hi,

got the same problem over here. I tried every Tip i was able to find, but i keep ending up with this Error that isn't an Error.

Can't anyone help out?

Regards Nic

OK, i got "kind" of an solution.
It seems to be an Problem of Drupal 6.19, because it only offers "mysqli" and "pssql" databases to logon to. But MAMP only creates an "mysql" Databases.
I downloaded Drupal 5.23 now and it "worked" out of the box, i keep getting several Error and Warning Messages but those belong to another case wich i will investigate now. ;)

It would be nice if someone could confirm my theory and/or provide help to use the newest version of drupal on MAMP.

Regards Nic

I was able to fix this by going to drupal/sites/default/settings.php and changing

$db_url = 'mysql://username:password@localhost/databasename'

to my database's username, password and databasename. Use with caution as I know little about drupal, but it worked for me.

Actually, you don't need to move Drupal inside the MAMP distribution. If you click on 'Preferences...' (I'm using the non-Pro version), you'll see an Apache tab. You can put the directory of any Drupal installation there. I do this all the time to switch between various development sites.

in the Terminal Applications/utilities/ click terminal to open a unix window.

Type
defaults write com.apple.finder AppleShowAllFiles TRUE

Then type

killall Finder This will kill all running iterations of Finder, so when you click on Finder, you will get a new iteration with the show all files toggle turned on.

You may turn this option off in the terminal by typing:

defaults write com.apple.finder AppleShowAllFiles FALSE
killall Finder

Thanks to http://www.techiecorner.com/153/how-to-show-hidden-files-in-finder-mac-o...

Mark White

Awesome directions. Worked perfectly for my install of Drupal 7 on my Mac using MAMP 2.0 and Mac OS 10.6 Snow Leopard. That's after I spent some time figuring out how to get the MySQL server to run (had to use the killall command in Terminal) and tried following the not completely helpful installation instructions in two different Drupal 7 books. Thank you.

I had a similar problem, the SQL server stopped and I couldn't restart it.
Luckily I had a professional in the office that fixed it.
Just run a terminal session and type:
ps aux | grep mysql

this will show you SQL processes that need to be "killed".
Just use "kill -9" and add the 4 digit process number of the SQL process.
Then you can restart SQL in your MAMP application.

Please be advised that the php.ini file in this release of MAMP is in:

/Applications/MAMP/bin/php/php5.3.6/conf

or

/Applications/MAMP/bin/php/php5.2.17/conf

It would appear that php4 has been eliminated from MAMP at this time.

Cheers and thanks for a great page!

Before upgrading til 256 MO (!!!), it was impossible to install some modules.
256MO is the same memory_limit as in my remote server. Big, but eficient !

Hi everyone

Being a total ignorant (Newbie) about Drupal (or CMS in general) I really appreciate tutorial like this where people like me can find "complete" answers ...

@@@ many before - I didn't have any problems understanding the entire post, it was very clear to me so I don't know why it should be rewritten. The only thing, yes, the Pro's sure would know it but for the novices it would be good to mention to enter the new password without any embracing such as <>, [] ...

The only thing I'd find really good for "Any" tutorial is mentioning the "version". Too often times I find myself reading tutorials (in general, not referring to this tutorial) but when applying anything from it, I find out it wouldn't work and in9/10 cases this is simply because I use a different version and since the version for the tutorial wasn't mentioned I'd just simply assume it would apply to any version.

Any tutorial written for anything that changes all the time (new versions hit the cloud every day) ... mentioning the version would be really be very helpful and timesaving. I hope my suggestion is not misunderstood but seen as a constructive critics

Thanks a lot to anyone in here for your support.

"Please edit the appropriate template (menu File > Edit template > ...)"

Start MAMP PRO and move your arrow to File (while you are in MAMP PRO and go to Edit template). This will open the MAMP PRO Editor and you MUST change memory with MAMP PRO Editor.

I've never before touched MAMP or Drupal... I was trying to find/do "Edit template" in Terminal, TextEdit, Aptana, looking in every file in MAMP folders for "Edit template"... I looked everywhere in the MAMP Pro panel that pops up. I never once looked up at the top menu.

(In case there are any more idiots as myself around!)

Here's how I got Drupal humming on MAMP (regular, not pro):

Specs

Computer: MacBook Air from Summer 2012
OS: Lion 10.7.5
MAMP: 2.1.1
Drupal: 7.19

Install MAMP and get Drupal running on it

Follow the steps in this article:

  1. Download MAMP
  2. Download Drupal
  3. Create the Drupal database

**If you have trouble with the "Create the Drupal database" steps, aren't concerned about security, and just want to get things going, then skip steps 7 through 16. Your database username will be "root" and your database password will be "root". This isn't recommended, but if you're just trying to get things going for local testing purposes, then this is fine. This would allow you to skip the "Changing your password" section too. Again, not recommended.

Adjust PHP's memory limit for scripts

In every php.ini file, I changed the memory limit from 8MB to 128MB. I even changed it in the php.ini.temp files that can be found in MAMP/bin/php/phpx.x.xx/conf/ (note that you'll find more php.ini files in this location -- change those as well). I also changed max execution times to 60s in every php.ini that I found it. Perhaps an overkill but I was going for the win.

memory_limit = 128M
max_execution_time = 60

Create a my.cnf file and make InnoDB the default storage engine

This was critical. Until I did this things were very slow and I was getting an error every time I flushed the cache or did anything on the modules page.

  1. Create the following blank file: /Applications/MAMP/conf/my.cnf
  2. Add the following two lines to it:

[mysqld]
default-storage-engine = InnoDB

(Note that MAMP regular -- not pro -- notably does NOT create the my.cnf settings file for you. So we're doing so.)

That's it! There are surely other performance tuning things you can do -- I imagine you could also tweak your my.cnf file in other ways -- but if you do these minimum things Drupal should run smoothly. This is from memory so let me know if anything needs clarifying.

I see an error in the main article here - to increase the memory limit, you need to edit the files in the "bin" directory of MAMP, not "conf"!

E.g. in my case it is /Applications/MAMP/bin/php/php5.4.10/conf/php.ini (adjust your MAMP install location and php version!)

Then you escape the need to change "all" php.ini files as someone here suggests. Found out the hard way, trying to setup xdebug for several hours.

Do something that matters!