The following content describes the solution for reporting the case of Can't create/write to file xxx during MySQL database running, if you are interested in its actual operations, you can watch it. I hope you will have a better understanding of it after browsing it.
MySQL (best combination with PHP) reports Can't create/write to file xxx during runtime
Solution
This problem usually occurs in windows because MySQL (the best combination with PHP) does not specify the default temp temporary directory.
Solution:
Modify the configuration file my. cnf of MySQL (the best combination with PHP)
Find [MySQL (the best combination with PHP) d:
Add the following line:
Tmpdir = C:/temp Note: path/is unix-style, not windows \ style)
Then confirm that the C: \ temp Directory requires the write permission for MySQL (the best combination with PHP ).
Restart MySQL (the best combination with PHP ).
The above content is an introduction to the solution to the problem of "Can't create/write to file xxx" reported by the MySQL database at runtime. I hope you will gain some benefits.