130422 InnoDB : Error : unable to create temporary file

[Harikrishna Ravipati]

Hi All,

I am new to Mysql, I am trying to install mysql in linux 5 CUI mode. I started with a) Setting up the basic environment
b) MySQL Installing MYSQL Database.

while running scripts/mysql_install_db --user=mysql i am getting errors and i am not able to run bin/mysqld safe --user=mysql & i am getting Issues.

I check the logs and i found below errors,

#cd /db/mysql/data

#tail -f test-lsm-r .err

/db/mysql/app/bin/mysqld: can't create/write to file '/db/mysql/tmp/ibDPBVqd' (Errorcode : 2)
130422 11:28:41 InnoDB: Error : Unable to create temporary file; errorno: 2
130422 11:28:41 [Error] Plugin 'InnoDB' init function returned error.
130422 11:28:41 [Error] plugin 'InnoDB' registration as a STORAGE ENGINE failed.
130422 11:28:41 [Error] Unkwon/unsupported storage engine: InnoDB
130422 11:28:41 [ERROR] Aborting


Kindly need any one of your support.

Note: I check /etc/init.d/
in that mysqld is not found it will come after DB create or before.


Regards,
Hari