Home ›
Setting up MAMP to work for the same scripts we use on the Debian serverSetting up MAMP to work for the same scripts we use on the Debian server
Submitted by Benjamin Melançon on April 21, 2008 - 8:47pm
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