mysqldatabasemysql-workbenchfile-location

File location for database created in MYSQL workbench


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. 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.