Mac os 下Mysql导出csv文件问题汇总

Mac os 下Mysql导出csv文件问题汇总

1、无法导出csv文件

报错：

ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so

配置文件的问题
SHOW VARIABLES LIKE “secure_file_priv”;
如果显示NULL
则需要访达下command+shift+G输入 /etc

然后找到my.cnf如果没有就要创建一个

创建内容就写：

# Example MySQL config file for medium systems.  
  #  
  # This is for a system with little memory (32M - 64M) where MySQL plays  
  # an important part, or systems up to 128M where MySQL is used together with  
  # other programs (such as a web server)  
  #  
  # MySQL programs look for option files in a set of  
  # locations which depend on the deployment platform.  
  # You can copy this option file to one of those  
  # locations. For information about these locations, see:  
  # http://dev.mysql.com/doc/mysql/en/option-files.html  
  #  
  # In this file, you can use all long options that a program supports.  
  # If you want to know which options a program supports, run the program  
  # with the "--help" option.  
  # The following options will be passed to all MySQL clients  
  [client]
  default-character-set=utf8
  #password   = your_password  
  port        = 3306  
  socket      = /tmp/mysql.sock   
  # Here follows entries for some