Posts tagged mysql

Home/Posts tagged mysql
Resetting MAMP's MySQL Root User Password

Resetting MAMP’s MySQL Root User Password

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.

read more
Starting MAMP’s Apache and MySQL Servers at Login

Starting MAMP’s Apache and MySQL Servers at Login

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.

read more
Changing the MySQL Root User Password in MAMP

Changing the MySQL Root User Password in MAMP

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.

read more
©Tech Otaku 2009 - 2017