Enquiry about MySQL Permissions

[Sarah Bird]

Anyone know anything about this?

From James Beard via the documentation website:

James Beard says:

January 10, 2013 at 3:41 pm

I think it is also necessary to
GRANT FILE ON *.* TO ‘myoxduser’@'localhost’;
If you don’t do this, the user can’t create temporary tables or files. The first symptom of things not working is that the openXdata admin user can’t change password on first login.

I’m using openXdata server 1.29. I guess it also might be MySQL version (or configuration) dependant – I’m using 5.1.46.

http://doc.openxdata.org/953#comments

--
skype: birdsarah
email: sb...@alum.mit.edu
web: www.sarahbird.org | www.bonvaya.com

[Dagmar Timler]

Hi Sarah/James.

Thanks for forwarding to the group - it's great to have feedback.

That command would definitely fix temporary file problems, but the command in the documentation should work (I have never had an issue and have setup new databases quite often). 

Because ALL includes FILE, the only thing I could think is that "*.*" instead of "myopenxdatadb.*" must have made a difference - perhaps during db setup the wrong database name was used in place of "myopenxdatadb"?

Thanks

Dagmar

--
You received this message because you are subscribed to the Google Groups "openXdata Users" group.
To post to this group, send email to openxda...@googlegroups.com.
To unsubscribe from this group, send email to openxdata-use...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

[Mark Gerard]

I think it may also depend on the environment you are running the MySQL and the user permissions  under which openXdata is being installed. I have experienced an issue where MySQL is denied write access to its own files primarily on windows machines and to some extent Mac OS X when I do not install with "sudo". So, you might have to check that.

Mark