MySQL displays Can't create/write to file 'C: \ Windows \ TEMP \ # SQL _990 _

MySQL Can't create/write to file 'C: WINDOWSTEMP # SQL _718_0.MYD (Errcode: 17) Solution

Error: Can't create/write to file 'C: WINDOWSTEMP # SQL _718_0.MYD (Errcode: 17)

The following situations may occur:

1. C: The WINDOWSTEMP folder has insufficient permissions. At least the read and write permissions of the USERS group must be given)
2. C: The WINDOWSTEMP folder is full and the file cannot be written. (clear the TEMP folder)
3. Your server is installed with MCAFEE antivirus software, and its access protection prohibits the writing of TEMP files. (modify the access protection settings)
4. For MCAFEE antivirus software, follow the steps below: Access scan properties-all processes-check items-scan files (when writing data to a disk) to remove the check items. OK.
5. C: WINDOWSTEMP clear the folder or delete # SQL _718_0.MYD'

The fourth method is relatively insecure. You can perform the following operations:

The host I encountered was win2003sp2 + php5.2.5 + mysql5.0.24. The specific solution is as follows:

Add a line in [mysqld] In my. ini

Tmpdir = "D:/mysqltmp/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.

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

Note: The default temporary directory for mysql is c: windowstemp.
Modify the McAfee VirusScan console-> scan by Access Program-> properties-> all processes-> check items-> scan files to write files, my method is relatively safer.

As for permissions, the mysql service uses system permissions by default and is generally fully controlled by the system. If necessary, you can also give the user a startup user.