I want to install MySQL on Mac OS X Yosemite, create a new user, then create a new database called "my_database". How can I do this?
What I've tried:
From command line,
brew install mysql. This succeeds and downloads MySQL to
Log into MySQL
mysql -u root.
I get an error in Step 2:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)`
I'm not sure how to fix this. I ran
ps ax | grep mysql which showed no MySQL processes were running. Then I ran
sudo /usr/local/bin/mysql start but I get the same
ERROR 2002 (HY000): Can't connect to local MySQL ....