title: MySQL Workbench doesn't accept JSON file (error 1290)
body: <p>I have a test suite that produces a .json file. I want to store the JSON file in MYSQL. I do not care how it stores it. I just want it in there so I can pull it out. </p>
  
  <p>After researching this online, I tried to do the traditional route through the GUI using Table Data Import Wizard:</p>
  
  <p><a href="https://i.stack.imgur.com/Qg0As.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Qg0As.png" alt="Using the GUI"></a></p>
  
  <p>I met with the following error:</p>
  
  <p><a href="https://i.stack.imgur.com/YBdwV.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/YBdwV.png" alt="Meaningless error"></a></p>
  
  <blockquote>
    <p><strong><em>Can't analyse file. Please try to change encoding type. If that doesn't help, maybe the file is not: json, or the file is empty.</em></strong></p>
  </blockquote>
  
  <p>The file is clearly not empty, and the file is valid JSON. I even went so far as to put it into an online tool that validates JSON. I looked online and other people have had this problem. So I changed the encoding to every option available in Notepad++. These include:</p>
  
  <ul>
  <li>ANSI</li>
  <li>UTF-8</li>
  <li>UTF-8-BOM</li>
  <li>UCS-2-BE-BOM</li>
  <li>UCS-2-LE-BOM</li>
  </ul>
  
  <p>Again, I still get the same error message. So I looked this up like a good stack overflow user so that everybody doesn't yell at me, and I see that this was <a href="https://bugs.mysql.com/bug.php?id=94536" rel="nofollow noreferrer">identified and verified as a bug in April of 2019.</a> This was in the 8.0.15 build. I am using the 8.0.19. I don't know if this was ever resolved because I require an Oracle account to view the progress logs (for some awesome unexplained reason). </p>
  
  <p>So I took an alternative route and just tried punching in the SQL Queries directly into My SQL Workbench. Big surprise, it doesn't work:</p>
  
  <p><a href="https://i.stack.imgur.com/vj6DK.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/vj6DK.png" alt="errorAgain"></a></p>
  
  <p>I get error 1290, which reads: </p>
  
  <blockquote>
    <p><strong>Error Code: 1290. The MySQL server is running with the --secure-file-priv option so it cannot execute this statement.</strong></p>
  </blockquote>
  
  <p>I <a href="https://stackoverflow.com/questions/31951468/error-code-1290-the-mysql-server-is-running-with-the-secure-file-priv-option">checked stack overflow</a> and tried the following solutions:</p>
  
  <ul>
  <li>commenting out <em>--secure-file-priv</em> setting in the linked my.ini file</li>
  <li>placing the json file directly into the "uploads" folder that the <em>--secure-file-priv</em> points to</li>
  <li>restarting MySQL / my computer'</li>
  </ul>
  
  <p>None of these worked. It also suggested replacing "\" with "/" in the filepath on that same page, but I fail to see where you would replace it. Replacing it in the filepath to the .json file in the query results in the same error. I don't see how you'd replace it on the path to executable, as there's no option to do that. </p>
  
  <p>Before everyone starts throwing things, here is some basic information everyone asks for:</p>
  
  <ul>
  <li>I'm Using Windows 10</li>
  <li>This is MySQL Workbench 8.0.19 </li>
  <li>This is using MySQL Server 8.0</li>
  </ul>
  
  <p>If someone actually knows how to fix this, I'd be very happy. </p>
  
  <p>I'm using windows 10</p>