• aliciagh posted a new activity comment 4 years, 1 month ago

    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.

  • aliciagh posted a new activity comment 4 years, 1 month ago

    Execute this sql sentence:

    grant create view on your_wordpress_database.* to ‘your_user’@’localhost';

    Thanks for use my plugin :)

    • Already run sql sentence on MySQL 5.0.91, receiving error messages: #1044 – Access denied for user ‘user’@’localhost’ to database ‘databasename’

      Thanks for your help.

      Regards,

  • aliciagh posted a new activity comment 4 years, 1 month ago

    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

      Im not an expert, can you guide me on how to do this ? MSQL 5.0.1 ready.

      Regards,

    • @aliciagh

      Already check user privileges on DB and find “create” and “drop” are allowed, however I did not find how to assign “create views” privileges.

      Where / how to do this ?

      Regards,