Setting up MAMP to work for the same scripts we use on the Debian server

Key words and phrases: 
phpMyAdmin change password using MySQL command line interface on a Mac MAMP CLI mysql paths Macintosh OS X MAMP path to mysql command line Can't connect to local MySQL server through socket '/var/mysql/mysql.sock mamp
Description & Info: 

I changed the mysql root password through phpMyAdmin... and promptly lost the connection– no! The password also has to be changed in MAMP's phpMyAdmin configuration file.

vi /Applications/MAMP/bin/phpMyAdmin/config.inc.php

$cfg['Servers'][$i]['password']      = 'changedpass';          // MySQL password (only needed

sudo ln -s /Applications/MAMP/tmp/mysql/mysql.sock /var/mysql/mysql.sock
sudo ln -s /Applications/MAMP/Library/bin/mysql /usr/local/bin/mysql
sudo ln -s /Applications/MAMP/Library/bin/mysqldump /usr/local/bin/mysqldump

(And finally Agaric's Debian script works on my MacBook, and I can quickly bring the live databases (databi?) down to development.

sudo /srv/scripts/_agaric-movedatabase.sh agaricdesign.com jonassoftware)

Resources

http://forum.akelos.org/discussion/148/problem-with-mysql-database/
http://blog.arc90.com/2008/03/mamp_mysql_command_line_access.php

by Benjamin Melançon
Posted on Mon, 2008-04-21 21:47
in
Post new comment
The content of this field is kept private and will not be shown publicly.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd> <blockquote> <h1> <h2> <h3> <h4> <h5> <h6> <small> <pre> <strike> <sub> <sup>
  • Lines and paragraphs break automatically.
  • Web page addresses and e-mail addresses turn into links automatically.
  • You may post code using <code>...</code> (generic) or <?php ... ?> (highlighted PHP) tags.

More information about formatting options

CAPTCHA
This question is for testing whether you are a human visitor and to prevent automated spam submissions.
  _____   _____   _   _____   _____ 
 |_   _| |  ___| / | |_   _| |___  |
   | |   | |_    | |   | |      / / 
   | |   |  _|   | |   | |     / /  
   |_|   |_|     |_|   |_|    /_/
Enter the code depicted in ASCII art style.