title: Creating table with error in mysql with Storage engine 'myisam' and data directory
body: <p>I tried to create a table with MyISAM as storage engine in mysql. But the query is failed to execute with following error code.</p>
  
  <p><code>Can't create/write to file '/Users/arun_kumar/Desktop/Test_DB_Data/Inde/myisam_data.MYI' (Errcode: 13)</code></p>
  
  <p>Following is the query I have used,</p>
  
  <pre><code>CREATE TABLE `test`.`myisam_data` (
    `tee_id` INT NOT NULL AUTO_INCREMENT,
    `name` TEXT,
    PRIMARY KEY (`tee_id`)
  )
  ENGINE = MyISAM
  CHARACTER SET utf8
  DATA DIRECTORY = '/Users/arun_kumar/Desktop/Test_DB_Data/Data'
  INDEX DIRECTORY = '/Users/arun_kumar/Desktop/Test_DB_Data/Inde';
  </code></pre>
  
  <p>Purpose of choosing myisam is it will support disk partition for different table, Where I need to store few tables in one disk and the remaining in another disk with in same database.</p>
  
  <p>Please help me on this.</p>