Mysql prompt safe paths import and export rights, has put the TXT in the security directory to open Mysql import file, still prompt permission problems, how to solve this? Already know the absolute path is an error, the export file also not line,

CodePudding user response:

With the following statement, query for import file path, to import the files in this directory path, can certainly,
If is the path, it may be the file format questions, such as
SHOW VARIABLES LIKE '% % secure;

CodePudding user response:

reference 1st floor AHUA1001 response:

with the following statement, query for import file path, to import the files in this directory path, can certainly,
If is the path, it may be the file format questions, such as
SHOW VARIABLES LIKE '% % secure;

Use , tried many times, don't know the reason why is because win10

CodePudding user response:

refer to the second floor l. saplings response:

Quote: refer to 1st floor AHUA1001 response:

with the following statement, query for import file path, to import the files in this directory path, can certainly,
If is the path, it may be the file format questions, such as
SHOW VARIABLES LIKE '% % secure;

Use , tried many times, don't know the reason why is because win10

I also use WIN10, handy.