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.

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

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

Answer 3

You likely didn't satisfy one of the requirements for "workbench" to be installed. Uninstall MySQL, and start the install process over. When you get a prompt something like "all of the requirements for the following programs have NOT been met"...check out what those requirements are. Usually something like a visual studio package. Go get that package, install it. Then start the MySQL install over again.