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.
精彩评论