Tag Archives: mysql

How to change the MySQL password in MAMP

Posted on October 2nd, 2010 by Ryan

Reinstalled MAMP last week because the version I was using didn’t have PHP 5.3 which I needed for a project I’m working on. Had to do some Googling to find the default password for MySQL and how to change. First, … Continue reading →

Posted in Computers & Internet | Tagged , , , , , , | Leave a comment

Grouping MySQL query by date

Posted on July 7th, 2009 by Ryan

Working on a statistics plugin I needed a way to group records by the day.  Turns out it’s remarkably easy. If you just want to group by year and month take off the DAY() part.  This would also be a … Continue reading →

Posted in Computers & Internet | Tagged , , , | Leave a comment