I have installed MySQL using Homebrew on my Snow Leopard Mac OS 10.6. I have run through the commands that it mentions:
unset TMPDIR
mysql_install_db --verbose --user=`whoami` --basedir="$(brew --prefix mysql)" --datadir=/usr/local/var/mysql --tmpdir=/tmp
ln -sfv /usr/local/opt/mysql/*.plist ~/Library/LaunchAgents
launchctl load ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist
But when I connect and try to list databases (or take any other action) I get errors:
$ mysql
mysql> show databases;
ERROR 1018 (HY000): Can't read dir of '.' (errno: 13)
I tried searching for an answer to the error, but couldn't find anything to help me resolve this issue. What do I need to do to set this up correctly?
FYI: I might have manually installed MySQL at one point. Not sure if there are any remaining files that are conflicting.