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.
The ability to remotely access a computer on a home network while away from home can often prove very useful.
Employing a technique known as SSH (Secure Shell) tunnelling this article describes how to securely access files on a remote computer using AFP (Apple Filing Protocol) and share that computer’s screen using VNC (Virtual Network Computing).
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.
Each device connected to a local network is assigned a dynamic IP address. There are occasions though when a a static IP address is needed instead. For example, port forwarding requires the destination computer on a local network to have a static IP address.
Using Mac OS X Lion 10.7.1, here are two ways of assigning a static IP address to a computer on a local network.