Getting command line access to PHP and MySQL running MAMP on OSX

By Joaquin Lippincott, CEO, January 26, 2009

If you have MAMP installed on your Mac OS X box, you're probably going to want command line access to those applications at some point. Assuming you're running a default install you'll run into difficulty when you type php or mysql without logging into the appropriate directory. In MAMP the directories are as follows:

/Applications/MAMP/bin/php5/bin/php
/Applications/MAMP/Library/bin/mysql

Rather than referencing those full paths every time you'll probably want to include them in the PATH. You can do this by editing your .profile file. (You can get to the directory where this lives by typing cd).

Use a text editor to open up .profile and change the following line:

export PATH=/opt/local/bin:/opt/local/sbin:$PATH

To include the additions to the $PATH like so:

export PATH=/Applications/MAMP/Library/bin/:/Applications/MAMP/bin/php5/bin/:/opt/local/bin:/opt/local/sbin:$PATH

You'll probably need to make the shell reload your profile like so:

. ./.profile

Also if you have any problems connecting to mysql you may need to run the following command:

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

Thanks to the following blog entries:
http://www.tech-recipes.com/rx/2621/os_x_change_path_environment_variab…

Comments

Matthijs Horsman

Wed, 03/25/2009 - 10:38

Thnxs :) That helped!

Bruce Garlock

Thu, 09/17/2009 - 16:01

Thanks for the post on CLI

Thanks for the post on CLI access with MAMP. Saved me some time.

Take care,

Bruce

Arifandi

Fri, 12/18/2009 - 05:11

Thanks this is also work for

Thanks this is also work for me and save me a lot of time.

Matthew Bacon

Sun, 12/27/2009 - 21:51

I am unable to find .profile

I am unable to find .profile under Snow Leopard. Upon opening Terminal, I have tried the command "open .profile" Telnet replies, "The file /Users/Matthew/.profile does not exist." Any suggestions?

Joaquin Lippincott

Mon, 12/28/2009 - 15:50

Hmm... I'm not running Snow

Hmm... I'm not running Snow Leopard, but you should be able to get to your home directory by typing:

cd

Once there try typing:

ls -al

That will give you a list of all of the files in that directory, including files that start with the . character that are otherwise hidden.

Matthew Bacon

Thu, 01/07/2010 - 18:38

To anyone who is having

To anyone who is having problems getting Zend_Tool working on their MAC OS X (10.6) in Terminal, this is how to solve the problem.

Step 1
---
Download the Zend Framework to your downloads folder. Once downloaded, rename the folder ZendFramework

Step 2
---
Open Terminal and type: sudo cp -r ~/Downloads/ZendFramework /usr/local/ZendFrameworkCli

Step 3
---
In Terminal, type: open ~/.bash_profile

Note: If file is not found...
---
Open the application TextEdit. Create a new file and make sure you are typing in plain text only. Type the following: alias zf=/usr/local/ZendFrameworkCli/bin/zf.sh

Save and exit TextEdit

Step 4
---
In Terminal, type: zf show version

Done!

Andrew Mallis

Wed, 08/11/2010 - 12:25

Thought I would update the

Thought I would update the instructions here for MAMP 1.9

The path has changed to
/Applications/MAMP/bin/php5.3
/Applications/MAMP/bin/php5.2

First, make MAMP's php executable
chmod +x /Applications/MAMP/bin/php5.2/bin/php

then edit your path for the version of PHP you want to use:
export PATH=/Applications/MAMP/Library/bin/:/Applications/MAMP/bin/php5.2/bin/:/opt/local/bin:/opt/local/sbin:$PATH

Joaquin Lippincott

Fri, 08/13/2010 - 02:07

Thanks, Andrew!

Tim

Thu, 02/28/2013 - 22:03

Looks like it may have

Looks like it may have changed again. I'm running MAMP v2.1.1 and I had to change the PATH to:

export PATH=/Applications/MAMP/Library/bin/:/Applications/MAMP/\
bin/php/php5.4.4/bin/:/opt/local/bin:/opt/local/sbin:$PATH

Joe Programmer

Thu, 03/10/2011 - 23:15

Thank you!

This was exactly what I was searching for, that symlink saved my - thank you!

Joel

Wed, 04/06/2011 - 21:44

thanks!!!!!!

thanks to all of the above !!

bruce allison

Tue, 05/01/2012 - 03:27

fixing password

I changed the password when I was in phpMyAdmin, the root by accident, then I got the following message:
/Applications/MAMP/Library/bin/mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect

How do I fix the root password in the terminal so that I can access the phpMyAdmin again.

diane

Sat, 07/07/2012 - 23:32

my password is not working in the terminal

hi I am trying to access mysql through the terminal and I keep getting this :Last login: Sat Jul 7 16:17:44 on ttys000
Diane-Friersons-MacBook-Pro:~ dianefrierson$ mysql -u root --password=admin-bash: mysql: command not found
Diane-Friersons-MacBook-Pro:~ dianefrierson$
I know that I'm connected because I use XAMPP and I can access mysql through the admin but I too am following a tutorial and would like to know both ways. please help thanks in advance.. Peace and Blessings

adam_norway

Thu, 10/04/2012 - 11:20

/Applications/MAMP/bin/php

/Applications/MAMP/bin/php/php5.4.4/bin/php
-c /Applications/MAMP/bin/php/php5.4.4/conf/php.ini
cron.php

(one line)

<a href="http:…

Tue, 03/13/2018 - 10:35

Nice

Just another post by admin. Your posts are really good for user.