[Solved] CREATE VIEW command denied to user...

[compuwatch]

MySQL gives me a hard time to create any VIEW (Table). Neither at the SQL command level GUI or with the MySQL Administrator. It is always the same error message. CREATE VIEW command denied to user "@"localhost' for table 'view1'. In case there is no way to create VIEWS with MySQL I will do it with a query. Kindly let me know what the problem might be.

As always,

Kind regards,
---------------
HANS

[compuwatch]

Thank you for your reply.

I found out (typical Rookie mistake) that I had to give SCHEMA priviledges. I selected all and then I was able to create views.

As always,