Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

MySQL Running SQL Script error - [WinError 32] The process cannot access the file because it is being used by another process:

Error Image

I am getting an error while running a SQL script to load data. Error is pasted below:

Preparing...
[WinError 32] The process cannot access the file because it is being used by another process: 'C:\\Users\\PRATIK~1\\AppData\\Local\\Temp\\tmpf75l0wi5.cnf'

I have tried uninstalling and installing MySQL several times but nothing is helping.

like image 502
Pratik Sinha Avatar asked Jan 26 '21 20:01

Pratik Sinha


People also ask

How to fix winerror 32 MySQL?

Something you can do is to change your MySQL configuration so it uses a specific Temporary path you'll set, restart MySQL and retry running the query. If you see the error contains your new temporary path you've isolated the issue, it is indeed a MySQL problem.


1 Answers

I faced the same issues while trying to run a MySQL script. I tried to find the process in the temp folder and removed it and tried again but the process seems to start again and appears in the temp folder. I could not run the script, however, I found a workaround, instead of running the script try to open it and run it in the query editor.

like image 178
M.rob Avatar answered Oct 06 '22 00:10

M.rob