Error Statrting MySQL on Mac OSx 10.6.8

gistfile1.txt

Problem:
  Starting MySQL
    - ERROR! The server quit without updating PID file (/usr/local/var/mysql/User.local.pid).

  ***mysqld tries to find its tables in /usr/local/var/mysql


Solution:
  ***change directories accordingly***

  Issue Command: "mysql_install_db --verbose --user=username --basedir="$(brew --prefix mysql)" --datadir=/Users/username/mysql-data --tmpdir=/tmp"

  Add file: "/usr/local/etc/my.cnf"
  With content:
    [mysqld]
    datadir=/Users/users/mysql-data

Then try running "mysql.server start" again