Where is the data stored in MySQL databases?

I don't know much about RDBMS but I am interested, I am working on a project which requires a database, I am planning to use MySQL to maintain that database. I have installed MySQL on macOS and I have created a database which has one table in it. now I have following questions in my mind : 1) Does turning on MySQL server turn my local computer into a server and stores databases in my computer when I create them using MySQL ? If so can I locate the database ? 2) Can I make a offline database using MySQL which can be located through 'Finder' ?