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

• Next in forum: Re: Trouble creating a MySQL 5 view
• Prev in forum: Re: microsoft site comptition
• Thread view: Trouble creating a MySQL 5 view

[Reply to this message]