MYSQL 工作台的文件位置
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/27416780/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
File location for MYSQL workbench
提问by Steve N
I created a database in 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.
我在工作台中创建了一个数据库，但找不到它所在的位置。我搜索了 xampp/mysql 文件夹并找到了一个 db.opt 文件夹，但没有其他任何内容。我还检查了 programdata/mysql 和programsX86/mysqlworkbench，但一无所获。
回答by Philip Olson
- Open Workbench
- Open the appropriate MySQL connection (the one you used to create the database)
- Open the "Management" tab in the Navigator (left pane)
- Open "Server Status" under "Management" to view information about your MySQL server
- Note the "Data Directory" path on that page
- 开放式工作台
- 打开适当的 MySQL 连接（用于创建数据库的连接）
- 在导航器（左窗格）中打开“管理”选项卡
- 打开“管理”下的“服务器状态”以查看有关您的 MySQL 服务器的信息
- 请注意该页面上的“数据目录”路径
This is where your recently created database lives.
这是您最近创建的数据库所在的位置。
回答by Altmish-E-Azam
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.
如果您使用的是 Windows，您可以在以下目录中找到您的 mysql 数据。假设您已经在 C 目录下的 Programming files 中安装了您的 mysql 服务器，那么您的 mysql 数据路径应该是。
C:\ProgramData\MySQL\mysql server version\data
In above directory you will get all created database folders with files.
在上面的目录中，您将获得所有创建的带有文件的数据库文件夹。
回答by user2977488
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.
您可能不满足安装“工作台”的要求之一。卸载 MySQL，然后重新开始安装过程。当您收到类似“尚未满足以下程序的所有要求”之类的提示时……请查看这些要求是什么。通常类似于视觉工作室包。去拿那个包，安装它。然后重新开始安装 MySQL。
