macos - mysql data directory location

Question

I installed mysql in Mac after downloding its dmg file version 64 bit. While trying to create a database it gave me error 1006 -- can't create database. After browsing a number of website, it seems due to user ownership setting of mysql "data directory" location that needs to be changed.

Where is mysql default "data directory"? I could not find /var/lib/mysql in localhost.

THANKS.

Answer 1

If the software is Sequel pro the default install mysql on Mac OSX has data located here:

/usr/local/var/mysql