ERROR 1 (HY000): Can't create/write to file in mysql Database

ERROR 1 (HY000): Can't create/write to file in mysql Database


I got the following error,

ERROR 1 (HY000): Can't create/write to file '/tmp/#sql_2e33_0.MYI' (Errcode: 13)

When I run the following query

SHOW  COLUMNS from users; (Equivalent to desc command in Oracle)



The problem is due to the permission .

I got the solution from the following link.

http://nixcraft.com/databases-servers/14260-error-1-hy000-cant-create-write-file-tmp-sql_9f3_0-myi-errcode-13-a.html

Execute the following steps in Terminal as root user.


chown root:root /tmp
chmod 1777 /tmp
/etc/init.d/mysql restart


The error got resolved successfully !