Where is the created MySQL database folder stored in Mac OS X?

mysql is found in /usr/local/mysql. Databases are stored in the data folder (/usr/local/mysql/data/databasename). This may be different depending on how you installed it.

Run this query:

SELECT @@datadir, @@innodb_data_home_dir

The exact files and or subfolders depend on the exact database name and table types.

For me, it's in /usr/local/var/mysql.