MySQL table Import export failed--the MySQL server is running with the--SECURE-FILE-PRIV option

Source: Internet
Author: User
Tags mysql version

When you read this article, it is estimated that the problem is also a headache;

Import and export as a text file, found always error, a lot of solutions, the following is the simplest and thorough method, record.

First, locate the My.ini file in the C:\ProgramData\MySQL\MySQL Server xxx.xxx directory

Note here that Programdata is a hidden file, perhaps you set the hidden file is not visible, need to be temporarily set back: Tools--Folder Options, show hidden files

Search in the My.ini file Secure-file-priv find and change its value to

Secure-file-priv= ', that is, assignment is empty. (I am MySQL version 8.0):

It's not over yet, you need to restart MySQL;

Win+r input services.msc Everyone service interface, find your MySQL, restart can;

If not, then you can restart the computer to try, not to forget, do not export haha

MySQL table Import export failed--the MySQL server is running with the--SECURE-FILE-PRIV option

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.