MAMP is specific application server developed for Mac operating system exclusively. It uses Mac OS, Apache as the wev server, database MySQL for data storage and use and PHP for making scripts.
This is an open source platform that provides an environment to the developers for developing websites.
MySQL is the relational DBMS for the data. The object oriented scripting language that is used in the development purpose is PHP. phpMyAdmin for MySQL and RockMongo for MongoDB can also be used for managing tables and databases.