I found the secret! Just ask mysql where it was looking for my.cnf. ini file wchiquito at 16:26 1 Yes, I closed it and restarted the program. dataelephant at 15:38 Did you restart MySQL after the change in the. The forum posts I found were split between many versions of MySQL and various operating systems. Running your exact command returns: 'requiresecuretransport' : 'off', 'secureauth' : 'on', 'securefileprive' : the directory where my file is saved. According to my research it was named my.cnf and located in one of dozens of different places depending on who you believe. To change secure_file_priv I first had to find the configuration file. The default value of secure_file_priv for the Homebrew install of MySQL 5.7.17 was NULL, which prevented me from writing with outfile entirely. Many of the forum posts I found were written before this change and were horribly confusing. Now the default value is platform specific and depends on the value of the INSTALL_LAYOUT CMake option, as shown in the following table.” Use these guides to get started: Install MySQL on Mac OS X Getting Connected Get Involved Sequel Pro is open source and built by people like you. Easy Installation Simply download, and connect to your database. Previously, the secure_file_priv system variable was empty by default. Sequel Pro gives you direct access to your MySQL Databases on local and remote servers. If secure_file_priv is set to a nonexistent path, the server writes an error message to the error log and exits. A non-NULL value is considered insecure if it is empty, or the value is the data directory or a subdirectory of it, or a directory that is accessible by all users. The server checks the value of secure_file_priv at startup and writes a warning to the error log if the value is insecure. “ secure_file_priv can be set to NULL to disable all import and export operations. The first key to removing confusion was learning this a change at MySQL version 5.7.6 No one had a complete answer though, hence I’ve been inspired to share my struggle and triumphant solution. I googled my heart out and read many pieces of advice across several different forum postings. Select * from reportSources into outfile '/Users/paulmccombs/reportSources.txt' ERROR 1290 ( HY000 ): The MySQL server is running with the -secure-file-priv option so it cannot execute this statement Oh, That’s What it Means!
0 Comments
Leave a Reply. |