First, you need upgrade MySQL to version 5.0.1. Request to the admin of your server for grant “create view” privilege on your WordPress database.
Execute this sql sentence:
grant create view on your_wordpress_database.* to ‘your_user’@’localhost’;
Thanks for use my plugin 🙂
The database user defined in wp_config.php have to have the “create view” privilege and the “drop” privilege. I’m talking about MySQL privileges.
Create view and drop view were added int MySQL 5.0.1 so the plugin requires MySQL 5.0.1 or greater.
@aliciagh active 1 year ago