File location for database created in MYSQL workbench

Question

I created a database in MySQL Workbench, but I can't find where it is located.
I searched the xampp/mysql folder and found a db.opt folder, but nothing else.
I also checked programdata/mysql and programsX86/mysqlworkbench and found nothing.

Solution 1

1. Open Workbench
2. Open the appropriate MySQL connection (the one you used to create the database)
3. Open the "Management" tab in the Navigator (left pane)
4. Open "Server Status" under "Management" to view information about your MySQL server
5. Note the "Data Directory" path on that page

This is where your recently created database lives.

Solution 2

If you are using windows, you can found your mysql data in below directory. Suppose you have installed your mysql server in Programming files under C directory then your mysql data path should be.

C:\ProgramData\MySQL\mysql server version\data

In above directory you will get all created database folders with files.