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.
I have several computers on my local network each with a local server environment provided by XAMPP. As it stands, the local server on each computer can only serve pages stored on that machine.
If I have a local site on computer A that I wish to access on computer B I have to replicate that site’s entire folder structure on computer B and on all other computers I want to access the site from.
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.