MySQL import data appears the MySQL server is running with the--secure-file-priv

MySQL import data appears the MySQL server is running with the--SECURE-FILE-PRIV option so it cannot execute this statement

Method One:

This is actually very simple because the import and export directory permissions are limited when MySQL is installed

Can only be imported under the specified directory

We need to see what the current value of Secure-file-priv is by using the following command

Show variables like '%secure% ';

We can see that value is/var/lib/mysql-files/

Then we'll change the imported path to the value above.

Method Two:

If this is too much trouble, then we need to change the configuration file, find the My.ini configuration file, modify the path, restart

MySQL import data appears the MySQL server is running with the--secure-file-priv