As I have told you the error "command denied to user" mean that your MySQL does not have enough privilege to share the MySQL user.
You have to increase the privileges of your MySQL user.
I don't know if you are using a hosting provider with cPanel or if you are using your own dedicated server, ....
but if you are not the MySQL administrator, perhaps you have to contact your hosting provider to grant the MySQL user and give you the permission.
This is a case explained in the tutorial video CP-02
www.jms2win.com/tutorial#jms12x-CP-02
If you have a MySQL root user that allow you increase the MySQL user permission, you can perhaps use the PHPMyAdmin interface to increase the permissions.
You have to provide the "CREATE VIEW and SHOW VIEW" permission to the MySQL user