Can "t create/write to file" C: \ WINDOWS \ TEMP \... MYSQL error Solution

Error message:

Error: Can't create/write to file 'C: \ WINDOWS \ TEMP \ # SQL _738_0.myd' (Errcode: 17) Errno.: 1

Problem Analysis:

1. The C: \ Windows \ TEMP folder has insufficient permissions. At least the readable and writable permissions of the USERS group must be given;

2. The C: \ Windows \ TEMP folder is full and files cannot be written. Clear the TEMP folder;

3. Third-party restrictions (such as anti-virus software restrictions)

1) your server is installed with MCAFEE Anti-Virus Software. Its access protection prohibits the writing of TEMP files and modifies the access protection settings;

2) The problem is still caused by MCAFEE Anti-Virus Software. Solution: simply remove the scan Attribute-all processes-check items-scan files (when writing data to the disk.