Posted by laredotornado on 01/05/07 17:00

Hi,

As root, I logged in to MySQL client and ran this command

GRANT ALL PRIVILEGES ON *.* to 'myuser'@'localhost' identified by
'mypassword';

Then I logged in as "myuser", selecting my database, and then tried to
create a view for a table that already exists:

CREATE VIEW SUMMARY_DAILY_SALES_TOTALS AS SELECT * FROM
SUMMARY_DAILY_TOTALS;

and got the error:

ERROR 1142 (42000): CREATE VIEW command denied to user
'myuser'@'localhost' for table 'SUMMARY_DAILY_SALES_TOTALS'

How can I resolve this error and create my view?

Thanks, - Dave

[Back to original message]