Can't create/write to file: ******.MYI" (Errcode:13)

Can't create/write to file: "C:\Users\USER\AppData\Local\Temp\#******.MYI" (Errcode:13)

It appears to be a permissions issue concerning MySQL's temporary folder. If you encounter Errcode 13 (signifying "Permission denied") while starting mysqld, it indicates that the server lacks the necessary privileges to access the data directory or its contents. In such cases, adjust the permissions for the affected files and directories to grant the server appropriate access rights.

      
To resolve the aforementioned issue, please follow the steps below:

Step 1: Show File Name Extensions
First, enable the display of file name extensions on the machine mentioned above.   [ Process to show File Name Extension ]

Step 2: Navigate to Temporary Folder
  1. Open File Explorer.
  2. Go to C:\Users\USER\AppData\Local\Temp
  3. Delete All Temporary Files.
Step 3: Create New Text File
  1. Right-click in the temporary folder.
  2. Select "New" → "Text Document".
  3. Name the new file exactly as the problematic file (e.g., "#sql_16d4_0.MYI").
      
Step 4: Set Proper Permissions
  1. Right-click on the temporary folder (C:\Users\USER\AppData\Local\Temp).
  2. Select "Properties" from the context menu.
  3. Go to the "Security" tab.
  4. Click on "Edit" to change permissions.
  5. Ensure that the folder has "Full control" or "Everyone" permissions.
  6. Click "Apply" and then "OK" to save the changes.
Step 5: Verify Issue Resolution
  1. Restart the system and check.

Now, verify whether the issue persists after opening the software. Hopefully, the problem does not recur.

    • Related Articles

    • Income Tax || Can't find file: 'it_*****.MYI' (error: 2) / error: 145 / error: 144

      If there is any sort of malfunctioning in executing the software and due to any reason if the software gets automatically closed /shutdown, the user would encounter the below errors. Solution: Please follow the below troubleshoot (on server system of ...

    • Cannot open file .myi (error: 145)

      If there is any sort of malfunctioning in executing the software and due to any reason if the software gets automatically closed /shutdown, the user would encounter the error 145 Solution: Please follow the below troubleshoot (on the server system of ...

    • Access denied for user 'root'@'localhost' (using password: NO)

      [MYSQL][odbc 3.51 Driver]{mysqld-5.5.5-10.4.10-mariaDB}you have an error in your sql syntax; check the manual that corresponds to your MariaDB server version for the right syntax to user near 'TYPE-MyISAM' at line 1 Cause : This error mainly occurs ...

    • Can't connect to MySQL server on 'LOCALHOST' (10061)

      MySQL is a relational database management system based on SQL – Structured Query Language. The application is used for a wide range of purposes, including data warehousing, e-commerce, and logging applications. KDK Software uses MySQL as its back-end ...

    • Spectrum\Taxsuit || Run time Error 70 - Permission denied

      Issue: Encountering security concerns on Windows 7, Windows 8, Windows 10 or Windows 11 while running the software. Resolution Steps: Navigate to Software Location: Go to either "C:\Program Files (x86)\K.D.K. Software\Spectrum" or "C:\Program ...