开发者

Syncing schema privileges in MySQL Workbench

Aloha,

I'm using MySQL Workbench version 5.2.34 and have created a database model as well as users & roles in the Schema Privileges section. My problem is that when I sync my model, the Physical Schemata will sync, but the users and roles do not. I've even tried to right click on the users & roles and click "copy sql to clipboard", but afterwards the clipboard is empty (it works when I copy the SQL to clipboard for any of my ta开发者_如何学Gobles). I've tried this in Workbench on my Windows XP machine as well as my OSX 10.6.7. Does anybody know what my problem may be?

Mahalo,

Frank


Don't choose Synchronize Model... from the Database menu . Instead, choose Forward Engineer... from the Database menu. This will add users and grant them privileges.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜