I recently installed mysql5.5 to my Windows 7 (x64) machine. The first problem was I couldn't enter the cmd client with mysql -u root -pmypass. The cmd opens, yields an error for like 0.5s and closes. Than I created another user account with all privileges, it worked and I created a database. But now I want to export that database from MySQL Workbench but I cannot see that in the "select a schema" option. I tried "new connection" and "new server instance" none worked. Any suggestions? Thanks in advance..
我最近在我的Windows 7(x64)机器上安装了mysql5.5。第一个问题是我无法使用mysql -u root -pmypass进入cmd客户端。 cmd打开,产生0.5s的错误并关闭。比我创建了具有所有权限的另一个用户帐户,它工作,我创建了一个数据库。但现在我想从MySQL Workbench导出该数据库,但我在“选择模式”选项中看不到。我试过“新连接”和“新服务器实例”都没有用。有什么建议?提前致谢..
1 个解决方案
#1
0
For the command line use WB too. In the list of connections you can right click for the context menu, which also offers to open a CLI window. In general, when you work with the CLI first open a normal CLI window (Start Menu -> Programs -> Accessories) and then try the mysql -u -p command. This way the CLI window won't close immediately and you can see what error message came out.
对于命令行,也使用WB。在连接列表中,您可以右键单击上下文菜单,该菜单还提供了打开CLI窗口的功能。通常,当您使用CLI时,首先打开一个普通的CLI窗口(“开始”菜单 - >“程序” - >“附件”),然后尝试使用mysql -u -p命令。这样CLI窗口不会立即关闭,您可以看到出现了什么错误消息。
For WB: if you don't see a schema you know is there then probably the user you used to connect has no permissions to see it. So for tests try connecting as root and see if your schema is there. Import and Export of db objects (including entire schemas) is available in the admin section, not in the SQL IDE (where you found "Edit Table Data" etc.).
对于WB:如果您没有看到您知道的架构,那么您用来连接的用户可能无权查看它。因此,对于测试,尝试以root身份进行连接,看看您的架构是否存在。 db对象(包括整个模式)的导入和导出可在admin部分中找到,而不是在SQL IDE(您找到“编辑表数据”等)中。
#1
0
For the command line use WB too. In the list of connections you can right click for the context menu, which also offers to open a CLI window. In general, when you work with the CLI first open a normal CLI window (Start Menu -> Programs -> Accessories) and then try the mysql -u -p command. This way the CLI window won't close immediately and you can see what error message came out.
对于命令行,也使用WB。在连接列表中,您可以右键单击上下文菜单,该菜单还提供了打开CLI窗口的功能。通常,当您使用CLI时,首先打开一个普通的CLI窗口(“开始”菜单 - >“程序” - >“附件”),然后尝试使用mysql -u -p命令。这样CLI窗口不会立即关闭,您可以看到出现了什么错误消息。
For WB: if you don't see a schema you know is there then probably the user you used to connect has no permissions to see it. So for tests try connecting as root and see if your schema is there. Import and Export of db objects (including entire schemas) is available in the admin section, not in the SQL IDE (where you found "Edit Table Data" etc.).
对于WB:如果您没有看到您知道的架构,那么您用来连接的用户可能无权查看它。因此,对于测试,尝试以root身份进行连接,看看您的架构是否存在。 db对象(包括整个模式)的导入和导出可在admin部分中找到,而不是在SQL IDE(您找到“编辑表数据”等)中。