I am new to mysql. I am connected to my MySql instance using MySQL Workbench. I have created a couple of databases in the system as well as users. I can quite easily generate scripts of the existing schema in the database.
However, i would like to generate creation scripts for one or more users that already exist in the system so that i can script the another environment (PROD) that has a completely blank MySQL instance.
Is there a way of relatively simple way of generating scripts for users for MySQL?