Tag Archives: mysql

How to change the MySQL password in MAMP

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

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