首页 >
mysql导出数据库出错:The MySQL server is running with the –secure-file-priv option so it cannot execute this statement
今天在导出mysql数据库里的某个表的某个字段里的所有数据时出错:
The MySQL server is running with the –secure-file-priv option so it cannot execute this statement
很明显是数据库secure-file-priv设置了不允许导出,
secure-file-priv的值有三种情况:
secure_file_prive=null ––限制mysqld 不允许导入导出
secure_file_priv=/path/ – –限制mysqld的导入导出只能发生在默认的/path/目录下
secure_file_priv=’’ – –不对mysqld 的导入 导出做限制
本人主机是用宝塔面板,所以直接在在mqsql设置里加上了
secure_file_priv =
就可以了,