XAMPP Slow on Windows 10

Posted by & filed under Programming.

Is XAMPP slow? I’ve used XAMPP for pretty much as long as I’ve been doing web development. It makes it trivial to get Apache, MySQL, and PHP set up.Since upgrading from Windows 7 to Windows 10 though I’ve noticed it was running much slower. I just assumed that XAMPP is slow. There was also an… Read more »

How to change the MySQL password in MAMP

Posted by & filed under Computers & Internet.

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, the default username is root and password is also root. To update to a password… Read more »

Grouping MySQL query by date

Posted by & filed under Computers & Internet.

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 good query to use WEEK() on to pull records grouped by the week they were… Read more »