Create View command

I am trying to create view of a table by making use of the following command "create view vendor_view.v as select * from vendor;" . But I get a message as

ERROR 1142: CREATE VIEW command denied to user 'myuser'@'%' for table 'v'

I tried to GRANT privileges to the user using the command

GRANT ALL PRIVILEGES ON mydb.* TO 'myuser'@'%' WITH GRANT OPTION;

But again I get the error as

ERROR 1044: Access denied for user 'myuser'@'%' to database 'mydb'

Could anyone suggest as to how can I grant privileges?

链接地址: http://www.djcxy.com/p/69276.html

上一篇: 无法在MySQL 5.6中创建用户

下一篇: 创建视图命令