You can get this error message when importing data.
Below are the steps to take to resolve the Secure-File-Priv flag problem.
So there are two ways to remediate the problem:
- You can go into you’re my.ini file in the MOVE directory and find the line secure-file-priv and edit to look like this: secure-file-priv=""
- Or,you can go into Workbench and change the server options there: options file -> uncheck secure-file-priv and restart the server.
Just say OK
Remove the check mark from secure-file-priv:
To apply the changes, look lower right hand part of the screen.
Restart the server. This is in your System Tray on the lower right-hand corner of your screen
Here’s where it is.
Click on the button and it expands to this:
Click on the MySQL icon and restart: