mysql5 problem with the CREATE VIEW command

[webquarry]

I put mysql5 on a machine and am letting some users play with it.

They have found that they do not have the abaility to create views:

CREATE VIEW VIEW_ALTERNATES
AS
SELECT * FROM alternates;

produces:

CREATE VIEW command denied to user 'user'@'localhost' for table 'view_alternates'

Any ideas?

 

[webquarry]

Found an answer.

This seems to happen to user accounts that are migrated to this machine from an older DA server running mysql4.1.

The users import into mysql5 just fine but the Create_view_priv,Show_view_priv are turned off in the mysql db table. Furthermore, the use is unable to use "create view" on any existing or new mysql database.

New system accounts created with DA are able to use "create view" perfectly.

Turning on Create_view_priv,Show_view_priv for the affected db users seems to fix the problem.

Is this a bug in DA user restore funtion that fails to setup the user in mysql5 properly?

 

[Icheb]

Sorry for kicking this post back into life, however we noticed this problem as well.

I think this indeed might be something like a bug, but I'm not sure. You can manually fix it on existing users by editing the mysql database called 'mysql', and changing the N's to Y's. However I believe DA should do that when they are not present in the existing backup that has been restored.

Are any other users also experiencing this issue?

 

[zEitEr]

Since 1.481 Da version Remaining User Privilege options added to MySQL User privileges section.

http://www.directadmin.com/features.php?id=1295