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. C: The WindowsTEMP folder has insufficient permissions. At least the read and write permissions of the USERS group must be given;

2. C: When the disk of the WindowsTEMP folder is full, the file cannot be written, and the TEMP folder is cleared;

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

Solution: start with my. cnf configuration.

Add a line in [mysql tutorial d] In my. ini

Tmpdir = "d:/mysql/temp /"

Specifies the directory for creating temporary files, which is used in a large number of queries.
Restart the mysql service to make it take effect.

 

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.

Open the McAfee VirusScan console-> scan by Access Program-> properties-> all processes-> check items-> exclude items-> Add D: mysqltemp
When the exclusion time is read and written.