User login

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

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

Resolution

Searched words: 
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

Comments

Thanks!

I came across your post trying looking to fix my connection to MAMP's MySQL install, so I can run mysqldump. After trying several other fixes, yours worked. This just made my day. Thanks!

Post new comment

The content of this field is kept private and will not be shown publicly.
  • You may post code using <code>...</code> (generic) or <?php ... ?> (highlighted PHP) tags.
  • You can use Markdown syntax to format and style the text. Also see Markdown Extra for tables, footnotes, and more.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd> <img> <blockquote> <small> <h2> <h3> <h4> <h5> <h6> <sub> <sup> <p> <br> <strike> <table> <tr> <td> <thead> <th> <tbody> <tt> <output>
  • Lines and paragraphs break automatically.

More information about formatting options

By submitting this form, you accept the Mollom privacy policy.