Re: mysql create table with data directory: access denied

[X X]

I have the same problem
try this:
GRANT FILE,CREATE TABLESPACE,EXECUTE on *.* TO `user`@`%`;

create table t1 (c1 int) ENGINE = InnoDB DEFAULT data directory = '/mnt/ramdisk/mysql';