MySql错误1064使用MySQL WorkBench分配架构权限时(MySql Error 1064 When assigning schema privileges with MySQL Wor

MySql错误1064使用MySQL WorkBench分配架构权限时(MySql Error 1064 When assigning schema privileges with MySQL WorkBench)

我刚刚在Windows 8 64bit上下载并安装了最新的MySQL版本（5.6）。 在安装过程中使用了默认值，它们都运行得很顺利。

使用MySQL Workbench我创建了一个包含一个简单表的模式，并创建了一个新用户。 在架构权限选项卡上，我为用户添加了一个新条目，按“选择所有”按钮选择权限，然后单击“保存更改”。 一旦我这样做，我得到他跟随错误：

任何想法为什么会这样？ 我是DB的新手，所以如果你有任何替代方法，我可以试试，请简单（一步一步）解释。

谢谢

I just downloaded and installed the latest MySQL version (5.6) on Windows 8 64bit. Defaults were used during install and it all ran smoothly.

Using MySQL Workbench I created a schema with one simple table and also created a new user. On the schema privileges tab I add a new entry for the user, press the Select "All" button to select the privileges and hit Save Changes. As soon as I do this I get he following error:

Any ideas why this is happening? I am very new to DB's so if you have any alternative methods I can try please explain in simple (step by step) terms.

Thanks

最满意答案

它似乎是MySQL Workbench中的错误＃68175 ：

包含下划线的数据库名称显示转义/导致SQL错误

它在上个月被报道并且它仍处于打开状态，因此您可以降级到5.2.46之前的版本，或等待它是否已修复。

It appears to be bug #68175 in MySQL Workbench:

Database names containing an underscore showing up escaped/ cause SQL Error

It was reported last month and it's still open so you can either downgrade to a version older than 5.2.46 or wait to see whether it's fixed.