Re: Vexing permissions issue with partitioned CREATE TABLE

[ceo]

I've never created a partitioned table, but...

$ perror 13
OS error code  13:  Permission denied

So I suspect some kind of file-system permissions issue...

Are you sure that the path you are giving isn't "relative" to the mysql data dir?

In which case it's trying to use something more like:
/var/mysql/data/foo/

Or, perhaps, you need to do the mkdir of idx_foo for it???

Or, perhaps, MySQL really doesn't like the idea of root-owned DB files, and wants them
owned by MySQL user?