title: mysql CREATE VIEW not working from mysql_query
body: <p>I have a code to create VIEW in mysql database which is working fine on my local server.
  It creates and crop view normally. But on my Online server it gives error</p>
  
  <pre><code>"CREATE VIEW command denied to user"
  </code></pre>
  
  <p>for online database I manually create VIEW in Database form PHPmyAdmin [Myadmin is in localhost online] it creating, SO i have permission to create VIEW on online database.</p>
  
  <p>But with php <code>mysql_query</code> it is giving <code>command denied</code> error. is there any service to be on for creating view with php.</p>