{"id":3224,"date":"2019-04-04T17:29:25","date_gmt":"2019-04-04T17:29:25","guid":{"rendered":"https:\/\/209.235.70.100\/?p=3224"},"modified":"2021-05-12T17:50:53","modified_gmt":"2021-05-12T17:50:53","slug":"mysql-error-1-hy000-cant-create-write-to-file","status":"publish","type":"post","link":"https:\/\/www.navisite.com\/blog\/mysql-error-1-hy000-cant-create-write-to-file\/","title":{"rendered":"MySQL ERROR 1 (HY000): Can’t create\/write to file"},"content":{"rendered":"\n

In my first post on the RDX Blog, I’ll be describing a common permissions error DBAs receive (Errcode: 13 – Permission denied) and how to address it. 
<\/p>\n\n\n\n

> desc foo_table;<\/code><\/pre>\n\n\n\n
ERROR 1 (HY000): Can't create\/write to file '\/tmp\/#sql_3ff6_0.MYI' (Errcode: 13 - Permission denied)<\/code><\/pre>\n\n\n\n
The error is documented here: https:\/\/dev.mysql.com\/doc\/refman\/5.6\/en\/cannot-create.html<\/a>
<\/p>\n\n\n\n
What happened to the permissions on the \/tmp folder? It is not allowing writes. First, we have to fix that then start looking into what or who changed permissions in the directory.<\/p>\n\n\n\n
chmod 1777 \/tmp\n\ufeff<\/code><\/pre>\n\n\n\n
I will use this error as an example..
<\/p>\n\n\n\n
First, look at the entire error message and do not focus on the first error you see. For example, if you have an Errcode:<\/p>\n\n\n\n
do not focus on ERROR 1\ndo not focus on HY000<\/code><\/pre>\n\n\n\n
You would be wasting your time since the Errcode gives you all the information you need. If that happened to be the only error message information that was passed along to you, then you do have resources available to look up errors:
<\/p>\n\n\n\n