mysql CREATE VIEW not working from mysql_query

Question

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

"CREATE VIEW command denied to user"

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.

But with php mysql_query it is giving command denied error. is there any service to be on for creating view with php.

Answer 1

This message says that user doesn't have enough permissions to create view. Permissions are granted to particular user @ particular host. You must execute

GRANT CREATE VIEW ON *.* TO 'username'@'host'; 

where host is hostname from where your CREATE VIEW is executed

Also, user must have SELECT privilages on all tabels and columns involved