Modify php.ini in MAMP PRO

Where is the php.ini file used by MAMP PRO?

You may have been wondering for a few minutes how the hell can you easily change the php.ini when using MAMP. I did.

I had to change the memory_limit because the initial setting is only 32M and it was not enough for the WordPress install I was running. So I looked into the folder Applications > MAMP PRO and then click on the right hand button to “see the package contents”, then a new folder opens and you can navigate into Contents > Resources. There are several php.ini files, each of them corresponding to one of the PHP versions included in MAMP PRO. In my case, I wanted to change the php ini corresponding to v. 5.3.27.

This is the file I had to edit:

/Applications/MAMP PRO/MAMP PRO.app/Contents/Resources/php5.3.27.ini

MAMP: how to use MYSQL from console

I could not access the mysql database from console, getting this error

ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ 

So I googled and found this:

http://fischerlaender.de/apple-mac/mac-os-x-trouble-with-mamp-mysql

and I sorted it out using:

sudo ln -s /Applications/MAMP/tmp/mysql/mysql.sock /tmp/mysql.sock

This will allow you to access through the console and do things such as

mysql -u root …

But now, there is an additional challenge. When I try to use the database through php (launching the console php -a), using sentences to connect such as mysql_connect(DB_HOST, DB_USUARIO, DB_PASSWORD) it will return the error

Warning: mysql_connect(): [2002] No such file or directory (trying to connect via unix:///var/mysql/mysql.sock) in php shell code on line 1

So, again searching in google, this is the solution: http://stackoverflow.com/questions/4219970/warning-mysql-connect-2002-no-such-file-or-directory-trying-to-connect-vi

sudo mkdir mysql

cd mysql/

sudo ln -s /tmp/mysql.sock mysql.sock