Clever Geek Handbook

File location for MYSQL Workbench

I have created a database in workbench, but I cannot find where it is located. I searched for the xampp / mysql folder and found the db.opt folder, but nothing else. I also checked programdata / mysql and programsX86 / mysqlworkbench and found nothing.

+3


source to share


3 answers


  • Open workbench
  • Open the appropriate MySQL connection (the one you used to create the database)
  • Open the "Control" tab in the navigator (left panel)
  • Open Server Status under Management to view information about your MySQL server.
  • Pay attention to the "Data Directory" path on this page


This is where your newly created database resides.

+9


source


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

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


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

+1


source


You probably haven't met one of the installation requirements for "Workbench". Uninstall MySQL and start the installation process. When you get prompted something like "all requirements for the following programs were NOT met" ... check what those requirements are. Usually something like a visual studio package. Go get this package, install it. Then start the MySQL installation again.

-1


source






More articles:


All Articles