MAMP’s MySQL root user password is set to root by default and changing it is not as straightforward as it perhaps should be.
Previously, I described how to successfully change the root user password providing that you know the current one. If not, this method will not work and a way of re-setting the root user password is required.
Installing WordPress on a local server environment is fairly straight forward. On a Mac the local Apache server may report Error 404 Object not found! errors as it attempts to serve WordPress posts and pages.
These errors can often be attributed to the use of pretty permalinks in WordPress. Stopping them from occurring can be achieved by a simple amendment to the Apache server’s configuration file.
Having MAMP’s Apache and MYSQL servers start at login is as simple as checking the Start Servers when starting MAMP option in MAMP’s preferences and adding MAMP.app to the Login Items.
However, some user intervention is needed if using the standard ports for Apache: 80 and MySQL: 3306 instead of MAMP’s default ports. In this case MAMP will require a password when it starts as port 80 is a privileged port.
Having recently changed my local testing server environment from XAMPP to MAMP v2.x I wanted to change the password for the MySQL root user. By default it’s set to root.
Changing the MySQL password for the root user was straightforward enough, but locating and editing the files to reflect the new password was a little more challenging.
For a while I was using the excellent swiftmailer which performed perfectly on both my local and remote servers for a while, but subsequently ceased working on my remote server.
A great alternative is the PEAR Mail package. Both MAMP and XAMPP come with the PEAR framework pre-configured, so installing the Mail package is straightforward.
The application MAMP provides a local server environment for your Mac separate to the one installed as default by OS X.
Both the premium and free versions of MAMP provide a single localhost, but unlike the paid version, the free one does not provide a nice interface to configure virtual hosts.
Configuring virtual hosts in the free version of MAMP has to be done manually.