[Ed Poor]

Hi, I'm completely new to PHP and MySQL and I'm using phpMyAdmin - 2.9.0.2 to create a view. I think my syntax is correct:

CREATE VIEW boston
SELECT * from contacts
WHERE city = 'boston'

but I get an error message indicating I don't have the correct privileges. This seems odd to me since I am the one who created the database! Do I have to assign myself greater privileges or log on under a different user name?

I can create and drop tables - why can't I create a view?

Ed Poor