Error:
Table storage engine 'MyISAM' does not support the create option 'CREATE TABLESPACE'
Solution
Just declare the engine as INNODB while creating tablespace because by default it must be picking MyISAM
CREATE TABLESPACE mytablespace ADD DATAFILE 'mytablespace.ibd' ENGINE=INNODB;
