Description:
When I am logged in as root with full privileges, I am still not permitted to create a view. I ran 'mysql_fix_privilege_tables.sql' just to be sure, but this did not help.
In version 5.0.2-Alpha I have the schema-privileges 'create_view' and 'show_view' to assign; in version 4.1.8 (and before) I do not have those privileges and (therefore?) I am not allowed to create views (in querybrowser, the commands (create view and create procedure) are not available either, they are present, but not selectable)
If I try to execute the command in querybrowser, (create view test AS select * from db) it results in: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'view test AS select * from db' at line 1 (errornr 1064)
Please help since I really need view(s) and I can not get it to work... ?!
Hardware: P IV, AMD Athlon XP and 64
OS: Windows 2000 standard server SP4, XP SP2, Windows 2003 standard server
Version: mysql-4.1.7-win and mysql-4.1.8-win,
mysql-administrator-1.0.18-win, mysql-query-browser-1.1.4-win
How to repeat:
Use mysql-4.1.7-win and mysql-4.1.8-win,
mysql-administrator-1.0.18-win, mysql-query-browser-1.1.4-win on a windows 2000+ platform, log in as root, use standard schema mysql, execute 'create view test AS select * from db' -> it won't work, not even after you assign all schema-privileges to root with mysql-administrator.