phpMyAdmin – Installing LAMP/MAMP on Snow Leopard/Mac Pro Part II

January 14, 2010

The only missing piece from the LAMP configuration was the phpMyAdmin package. So I did the following:

  1. Downloaded the zip file for phpMyAdmin from www.phpmyadmin.net
  2. unzip the downloaded fie
  3. rename phpMyAdmin…3.2.5 to phpMyAdmin
  4. copy the directory to the apache server location(/Library/Webserver/Documents)
  5. FAQS stated – you need to create your own config.inc.php. I started from config.sample.inc.php
  6. Go to http://localhost/phpMyAdmin which should show you the login view

My config.inc.php is displayed below

Continue reading


Installing LAMP/MAMP on Snow Leopard/Mac Pro Part I

January 14, 2010

I am coming from a windows background and loved the simplicity and ease of use of WAMP when it came out. So I looked for the comparable package for my new Mac Pro. I had heard about MAMP so I jumped on that package.

I used this article from Sitepoint to get started: Build Your Own Database Drive Website Using PHP and MySql, Part I: Installation. If you are starting out, I highly recommend buying this book to get you up and running. I followed the directions to install MAMP. I was rather disappointed. I guess the comparable package to WAMP is MAMP Pro. I had the following problems:

  • MySQL socket – even after I set the socket to the default of 3306, it kept reverting to 8889 after I stopped and started MAMP
  • MySql startup was error prone and the logs spewed out warnings using the default mysql settings which have been noted on other sites(lower_case_table_names warning,Plugin ‘FEDERATED’ is Disabled,plugin ‘ndbcluster’ is disabled, can’t find a file ./mysql/plugin.frm’,etc)
  • Missing ini files – my.cnf or my.ini,php.ini
  • Tried to configure the system to start automatically on startup using plist files unsuccessfully, mainly because of mysql issues

Continue reading