解决问题:
windows下：修改my.ini 在[mysqld]内加入secure_file_priv =
linux下：修改my.cnf 在[mysqld]内加入secure_file_priv =
MYSQL新特性secure_file_priv对读写文件的影响
然后重启mysql，再查询secure_file_priv
相关文章
- 解决 The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement
- The MySQL server is running with the --read-only option so it cannot execute this statement
- mysql错误：The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement解决方法
- 1290 - The MySQL server is running with the --secure-file-priv option so it cannot execute this statement