Reporting DB Views

If you use MySQL as a database, run the following command to grant permissions to the user to create DB views:

GRANT CREATE VIEW ON <DatabaseName>.* TO 'root'@'%';

DatabaseName: Defines the name of the MySQL database where the user can create views.