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

Where is the created MySQL databas开发者_JAVA技巧e folder stored in Mac OS X?

---

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.

---

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.

---

I installed mysql (Ver 8.0.31 for macos13.0 on arm64) using Homebrew 3.6.12 the databases are stored here /opt/homebrew/var/mysql/