0

Have inherited a MySQL database that was completely trashed by the latest Windows 10 build update. The server lost all the user and schema information.

I restored the database back and recreated the users, set all the permissions etc. Obviously I would like to mitigate against this happening in the future but can see no obvious way from workbench to generate a script to create the users and set the permissions as you would from SQL management studio.

Is this possible?

mmacneill123
  • 33
  • 6

1 Answers1

-1

Yes this is possible.

You can execute requests with a batch that is loaded by MySQL with a command from the shell to make what you want done.

I had not tested it myself but I think this link could be helpful.

PREVOST Corentin
  • 39
  • 8
  • Not sure this is what I am after - I was looking for SQL workbench to generate the script to create the users and set the permissions for each user. This link is about executing the SQL once you have it :-) – mmacneill123 May 18 '16 at 13:15