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:WindowsTEMP folder permissions are not enough, at least the read and write permissions of the USERS group must be given;
2. The disk in the C:WindowsTEMP folder is full and files cannot be written to it. Clear the TEMP folder;
3. Third-party restrictions (such as restrictions on anti-virus software)
1) Your server is equipped with MCAFEE anti-virus software, and its access protection prohibits TEMP files from being writable. Modify the access protection settings;
2) It’s still a problem with the MCAFEE anti-virus software. The solution steps are: press-access scan properties - all processes - detection items - scan files (when writing to disk) and uncheck it.