Using MySQL command line with MAMP

To use the MySQL command line with MAMP or MAMP PRO, perform the following steps:

1. Start MAMP or MAMP PRO
2. Start the server
3. Open Terminal (Applications -> Utilities)
   Type in: (one line)
   
/Applications/MAMP/Library/bin/mysql --host=localhost -uroot -proot
   

Now you can use the MySQL command line. For exmaple to show all your databases with show databases;.

Using MySQL command line with MAMP

How-to: Using the local Mac OS X FTP Server with Espresso

We already showcased how to start the built in FTP server of Mac OS X and how to access it with the FTP Client FileZilla.

Today we want to demonstrate how to connect to the FTP Server using Espresso (provided by the guys from MacRabbit):

1. Start Espresso
2. Create a new project by going to File -> New Project
3. Click on "New Folder" and choose "Create Project"
   
   
4. Enter a name for the directory and choose where you want to save it
   
   
5. Click on "Settings" at the upcoming window
6. Click on "Add Server" on the right
   
   
7. Enter a name into the field "Nickname". I'm choosing "Local"
8. Leave the standard setting to "FTP" at the select box
9. The field "Port" can be left blank
10. Enter your IP address into the field "Server". Not sure about your IP? Take a look at our post "How to: Access FTP with MAMP"
11. Enter your user name into the field "User Name"
12. Enter your password into the field "Password" (Username and password are the same which you are using to access Mac OS X)
13. Enter the favored directory into the field "Remote Path". On my System this is: "/Users/dirkeinecke/Documents/Websites/MAMP-Server/test"
    
    
14. Click on "Save" on the upper right corner
15. Now we want to establish a connection
16. Click on "Local" (your nickname) at the sidebar on the left
17. Now you will see a button "Connect" on the right. Click it.
    
    
18. The connection has been established and you are done!
    
    

How-to: Using the local Mac OS X FTP Server with Espresso

Installation de Drupal

I don‘t speak French, but I understand this screencast by Nanak Morgan Milet covers the installation of the CMS Drupal.

Installation de Drupal

How to: Access FTP with MAMP

Sometimes you may need FTP access for your local development with MAMP or MAMP PRO. Therefore you can use the FTP server built into Mac OS X. The ftp server is not activated by default. To activate the server follow these steps:

Note: This tutorial uses Snow Leopard 10.6 but in general this also works with older Versions of Mac OS X.

1. Open System Preferences
2. Go to "Sharing"
   
3. Activate "File Sharing"
4. Click on "Options"
5. Acitvate "Share files and folders using FTP"
6. Click on "Done"
7. Below the entry "FTP Access: On" you will find a text "Other people can access your FTP server atftp://10.0.1.200/ or browse for “Dirk Eineckes MacBook Pro 17"”."
   
8. Write down the IP Address
9. Close the preferences panel
   

Now you have activated the FTP server and you can access it with any FTP client like Cyberduck or FileZilla. Per default you will be directed to your home directory. But most commonly you want to access a certain directory on your hard drive instead of accessing your home directory.

How this works we will showcase with the free FTP client FileZilla:

1. Start FileZilla
2. Go to File -> Site Manager
   
3. Click on "New Site" in the upcoming dialogue
4. Choose a name at the tree on the left (like "Local")
5. On the right enter your IP Adress into the field "Host"
6. Choose "Normal" at the select box "Logontype"
7. Enter your username into the field "User"
8. Enter your password into the field "Password". (Username and password are the same which you are using to access Mac OS X)
   
9. Click on the tab "Advanced"
10. Enter your favored directory into the field "Default remote directory". On my system this is: "/Users/dirkeinecke/Documents/Websites/MAMP-Server/test"
    
11. Click "Connect"
    

You are done!

How to: Access FTP with MAMP

MAMP & MAMP PRO are fully compatible with Snow Leopard

Apple's latest $29 update to OS X Snow Leopard ships this Friday (partner link)—but will all of your essential applications run when you install it?



MAMP & MAMP PRO are fully compatible with Mac OS X 10.6, Snow Leopard, the forthcoming version of Apple’s operating system. Snow Leopard will be released on August 28, and the curent version (1.7.2) of MAMP & MAMP PRO is already compatible with the new operating system.

MAMP & MAMP PRO are fully compatible with Snow Leopard

WordPress from scratch with MAMP (Part 2)

The second part of Nouveller's 'WordPress from scratch' series by Benjamin Reid.

This second part covers taking the XHTML, CSS and images into a WordPress theme and getting WordPress to recognise this. Stay tuned for part 3 where we'll get into the really juicy stuff!



* Please note that the volume seems to be quite low in this one, so please turn it up. The next one will be louder, promise.

WordPress from scratch with MAMP (Part 2)