I have a MySql server installed on a server along with MySql Workbench.
About a year ago, I managed to do this and I felt like slapping myself as it was something so simple, but, I just can't remember what it was.
So far, I have created a new schema and created a new user.
When I click on the user and go to the
Schema Permissions section, it is simply blank, and no matter what I try, I can't seem to populate the right hand side.
In addition, before this, I remember that MySql used to ship with the Admin tool - this was much more straight forward... but, it was old and doesn't seem to connect to the new version of MySql.
Sathya has suggested Toad, and, I will install this if no one else can come up with a solution. I am not completely against scripting a solution, but, I know this is possible and it is driving me mad that I can't figure it out - so, I would much prefer an answer that involves MySql Workbench.