Creative Juices Bo. Co.

Satisfy Your Thirst For Something Refreshing!

Installing MySQL 5.5.8 on Mac OS X Headache

MySQL We Have A Problem

Argh... So I wanted to update my internal server to the latest and greatest version of MySQL. I downloaded the nice Mac OS X ver. 10.6 (x86, 64-bit), DMG Archive installer package they have and low and behold, MySQL won't start-up!

Well, no need to worry. Seems to be an issue with the installer package. To see if you have the same problem I'm having, do the install and then fire up ye ole terminals and type:

sudo /usr/local/mysql/support-files/mysql.server start
Password: XXXXXX

If you see a fun message that looks like this:

/usr/local/mysql/support-files/mysql.server: line 256: my_print_defaults: command not found
Starting MySQL
ERROR! Couldn't find MySQL server (./bin/mysqld_safe)

Then you have the same problem I'm having. Here's how you can fix it.

read full article...

MySQL DATE_FORMAT() Returning Binary Data

Taming the MySQL Date_Format Function

MySQL LogoThis is just a quick post of a little problem I've been running into lately. I'm not sure if it's a bug or some kind of intended MySQL thing, but it's annoying as heck. Also, I'm using MySQL version 5.0.32. I'm not sure if this applies to older versions of MySQL or not, but it seems to be something new with the 5.0 variants.

read full article...