Can MySQL have one file per database?
===

I like the fact that a Microsoft Access `.mdb` file contains a complete database in a single file, so for example `foo.mdb` may contain all the data, table structures and queries for one database.

I want to move over to MySQL. I understand that MySQL can use many file structures. Can MySQL replicate the single file model of one database = one file?