As you will read plenty of times in this forum the error "command denied to user" means that you don't have a MySQL user that has the permission to share mySQL table (create or show views)
So update the privilege of the MySQL user that you are using for that.
See also the tutorial video 0.b slide 35 that show how to add the create and show view with a PHPMyAdmin and the root login.
www.jms2win.com/en/tutorial#jms12x-0b
If you are using shared hosting, contact your hosting provider to ask him increase your MySQL user privileges?