Category: MySQL

A Simple Set of Time Utilities for PHP

php5.4-300x300Haven’t you ever wished you had an easy to use chronograph, set of constants representing the days of the week, or perhaps months of the year? Maybe you have forgotten the exact format to use when writing datetime’s to a MySQL database (i.e. ‘Y-m-d H:i:s’). I know I have.

Read more…

Install MySQL on Mac OSX using Homebrew

UPDATE: This post is probably very out of date. Please use at your own risk.

mysqlRecently, while doing some development on my Mac, I realized I didn’t have MySQL installed. I could have loaded up an instance of Ubuntu 12.04 LTS on VirtualBox and used that. However, I thought it would be much more convenient to have it available directly instead in a virtualized environment. Here are the instructions for installing it on a Mac using Homebrew.

This guide assumes Homebrew is installed and properly functioning.

Read more…

Building the Perfect Ubuntu 10.04 LAMP Server

This post will detail the series of steps that are required to set-up and configure a LAMP server using Ubuntu 10.04 LTS. The server will have all of the normal features that everyone has come to expect.

Specifically, it will have the following features:

  • Locales will be set properly.
  • MySQL will be secured.
  • MySQL Query Caching will be configured.
  • Iptables will be configured (optional).
  • Alternative PHP Cache (APC) will be installed and configured.
  • Web directory permissions will be set.
  • Virtual hosts will be created.

Read more…

Resetting the MySQL Root Password

This post will describe the series of steps that are needed to reset the MySQL root password when either the root password is known or it is not known. In theory, the later should never happen. However…

“In theory, there is no difference between theory and practice. In practice, there is.”
-Yogi Berra

Read more…