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中创建用户
下一篇: 创建视图命令