› MySQL 5.5 Community Server
› MySQL 5.6 Community Server
› Percona Configuration Wizard
› XtraBackup 搭建主从复制
Great Sites on MySQL
› Percona
› MySQL Performance Blog
› Severalnines
推荐管理工具
› Sequel Pro
› phpMyAdmin
推荐书目
› MySQL Cookbook
MySQL 相关项目
› MariaDB
› Drizzle
参考文档
› http://mysql-python.sourceforge.net/MySQLdb.html
xixiliya
V2EX  ›  MySQL

请问 secure-file-priv 修改无效是什么原因?

  •  
  •   xixiliya · Sep 23, 2019 · 6206 views
    This topic created in 2562 days ago, the information mentioned may be changed or developed.

    linux 服务器,用宝塔搭建的测试站,需要从数据库中导出数据到文件里面。 提示“The MySQL server is running with the --secure-file-priv option so it cannot execute this statement ” 1.修改 /etc/my.cnf,添加 secure_file_priv =、secure_file_priv =""、secure_file_priv ="/tmp/"、secure_file_priv =/tmp/等等,全部都试过。无果 2.每次修改后在宝塔重启 mysql 服务,并重新加载 mysql 配置。无果 3.用 ssh 去重启 mysql、重启宝塔等,均无果。 4.每次查询 show variables like '%secure%',secure_file_priv 的值都是 null

    实在不知道问题出在哪了,求教!

    No Comments Yet
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Privacy   ·   Solana   ·   2904 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 23ms · UTC 13:36 · PVG 21:36 · LAX 06:36 · JFK 09:36
    ♥ Do have faith in what you're doing.