Re: ROLES OR GROUPS WHILE ASSIGNING PRIVILEGE

[Darren Cassar]

basically you need to:

Import db/securich.sql in order to create the `securich` database with all it's tables
Import all procedures in procedures thus creating all stored procedures necessary
Import db/data.sql populating the "privileges, roles (read and write roles), databases, tables, stored procedures" tables

importing any of the above is done:
mysql -u root -p --socket=/tmp/mysql.sock < "filetoimport.sql" where filetoimport.sql is the name of the file you need to import ie db/securich.sql for example.

Then create the roles using `call create_update_role('rolename','privilegetype');