For help, with half a day
Windows, 5.7.20 free installation, the load data infile show error when importing 1290, secure file priv option to show the variables like secure "% %" display null, searched the is my ini problem, in my. Ini/mysql below and secure - file - priv=', (or space, or the specified directory), restart the mysql, or null
Search in the service and the executable file path is "C: \ Program Files \ mysql (x86) - 5.7.20 - winx64 \ bin \ mysqld" mysql
Seek help from a great god!

CodePudding user response:

When the value is null, of secure_file_priv said limit mysqld is not allowed to import | export

Not/mysql below add

Should be below the [mysqld]

CodePudding user response:

Write wrong, is under the [mysqld], and still won't do, after the restart still is null

CodePudding user response:

Either no start, or change the wrong configuration file
Check your MySQL service properties, check service startup parameters specify the configuration file

CodePudding user response:

It was launched,, but in the bin and I was not find mysqld this configuration file, only mysqld. Exe but open the didn't also things with command line

CodePudding user response:

MySQL5.7 in my. Ini, the MySQL ProgramData folder.
Modify the my. Ini

CodePudding user response:

Service is started, but have to restart this look not to come out, you can use the MySQL logs, or execute queries show status like 'uptime. To confirm the
If confirm weight is still no effective, and may change the configuration file is wrong, your service is not specified in the configuration file location, so refer to the following instructions to confirm the club's official website the location of the configuration file
https://dev.mysql.com/doc/refman/5.7/en/option-files.html

Finally, take a look at the MySQL log file have any relevant error/warning information