MAMP Config

httpd.conf

LOCATION: /Applications/MAMP/conf/apache/httpd.conf

Open the file and Alter Line 48

Old:

Listen 8888

New:

Listen localhost:8888

my.conf

# The MySQL server
[mysqld]
bind-address=127.0.0.1
character-set-server=utf8
collation-server=utf8_general_ci
socket= /Applications/MAMP/tmp/mysql/mysql.sock
#skip-locking
ft_min_word_len=3
key_buffer_size = 384M
max_allowed_packet = 32M
table_open_cache = 256
sort_buffer_size = 4M
read_buffer_size = 2M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size =4096M
thread_cache_size = 8
query_cache_size= 32M
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 4

#skip-networking

# Uncomment the following if you are using InnoDB tables
innodb_data_home_dir = /Applications/MAMP/db/mysql/
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /Applications/MAMP/db/mysql/
innodb_buffer_pool_size = 384M
innodb_additional_mem_pool_size = 20M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 3
innodb_lock_wait_timeout = 500


[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash

[myisamchk]
key_buffer_size = 128M
sort_buffer_size = 4096M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout