1. Enter Mysql to view secure_ file_ The value of print

$mysql -u root -p

mysql> SHOW VARIABLES LIKE “secure_ file_ priv”;

secure_ file_ Prive = null — restrict mysqld from importing and exporting

secure_ file_ Priv =/TMP/– restrict the import and export of mysqld to/TMP/

secure_ file_ Priv = ‘– no restrictions on the import and export of mysqld

Similar Posts:

• When MySQL uses select statement to export table data, error 1290 is reported
• [Solved] MYSQL Export Sheet Error: –secure-file-priv option so it cannot execute this statement
• How to Solve MySQL Secure file priv error
• [Solved] MySQL Import csv File[Error Code] 1290 – The MySQL server is running with the –secure-file-priv option
• MySQL import file prompt — secure file priv option problem
• [Solved] MYSQL ERROR 1290 (HY000): The MySQL server is running with the –secure-file-priv option so it cannot e…
• Loading local data is disabled; this must be enabled on both the client and server sides　
• mysql ERROR 1044 (42000): Access denied for user ‘
• MySQL reports an error using load data local infile
• MySQL external import data error [How to Solve]