![]() Applications/MAMP/Library/bin/mysqlcheck -all-databases -check -check-upgrade -u root -pNEWPASSWORD -socket=/Applications/MAMP/tmp/mysql/mysql.sockįile: /Applications/MAMP/bin/quickCheckMysqlUpgrade.sh * For files marked * an easy way to locate the old password is to search for the string -proot where -p is the password option and root is the old password.įile: /Applications/MAMP/bin/checkMysql.sh * Next, all the occurrences of the old password root need to be changed to the new password NEWPASSWORD in the following files. You’ll be prompted for the current root password: ![]() Applications/MAMP/Library/bin/mysqladmin -u root -p password NEWPASSWORD To change the MySQL password for root ensure that MAMP’s MySQL server is running then open Terminal and type the following, replacing NEWPASSWORD with the password of your choice: They are applicable to MAMP versions 2.x, 3.x, 4.x and 5.x but be aware of the slight difference in the changes required. These instructions are for the free version of MAMP not MAMP Pro. If you’ve forgotten it please refer to Resetting MAMP’s MySQL Root User Password. These instructions are for changing a known password for the root user. ![]() Information on MAMP’s own site appeared incomplete and other documentation I found - while helpful - was for versions of MAMP prior to version 2. Applications/MAMP/Library/bin/mysqlcheck: Got error: 1045: Access denied for user (using password: YES) when trying to connect Failure to update all the necessary files results in MAMP reporting the following error: By default it’s set to root.Ĭhanging the MySQL password for the root user was straightforward enough, but locating and editing the files to reflect the new password was a different story. Note: Tom has pointed out in the comments that in MAMP 2.1.1 You are unable to run MAMP's PHP from the command line so you will need to update MAMP first.Having recently changed my local testing server environment from XAMPP to MAMP v2.0.5 I wanted to change the password for the MySQL root user. bash_profile and reload your profile by typing source ~/.bash_profile and run which php, and if you've done everything right should say /Applications/MAMP/bin/php/php5.4.4/bin/php. It's important to append the existing $PATH at the end otherwise the version of PHP in /usr/bin/php will be found and loaded first instead. profile if you are using a different shell and add the MAMP version of PHP to the PATH variable.Įxport PATH=/Applications/MAMP/bin/php/php5.4.4/bin:$PATH So we just need to swap this over to the PHP that is installed with MAMP, which is located at /Applications/MAMP/bin/php/php5.4.4/bin (MAMP 2.1.1). So I ran which php and I'm told I'm running /usr/bin/php which is the version of PHP that comes preinstalled with OS X. Which looks pretty simple to fix but MAMP should have this setting disabled. The detect_unicode setting must be disabled.Īdd the following to the end of your `php.ini`: ![]() Make sure that you fix the issues listed below and run this script again: Some settings on your machine make Composer unable to work properly. After just trying to install composer I ran into a little problem which I thought was worth sharing.Īfter running curl -s | php, I get the following error: Which is a great little tool and I'm really happy to see the community getting behind it and moving forward. One tool I have been playing with recently is Composer which is a dependency manager, think Ruby Gems but for PHP. This has given me a great opportunity to configure my development environment in a cleaner and more organised way.Īs a developer I do install a number of packages to play around with and then either decide its not for me or find there was a better way configuring them and then find myself in a bit of a muddle. After my laptop has been running really for a couple of weeks now, I have decided to order some new RAM and do a clean install of Lion.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |