Naturally, you can point the secure-file-privs variable to another location of your choice. | 6 | 'Natasha' | 'Romanoff' | 'Black Widow' | | 3 | 'Steven' | 'Rogers' | 'Captain America' | | 2 | 'Thor' | 'Odinson' | 'God of Thunder' | | avenger_id | first_name | last_name | character_name | I put the avenger.csv file in the following directory pointed to by the secure-file-privs value in the my.ini.The only way that the LOAD command would work required the following steps:
Then, I found my error in the SQL LOAD command. It appeared that I may have to remove the secure-file-priv setting from the my.ini file and reboot the server. Unfortunately, with all these set appropriately the secure-file-priv variable appears to block reading files from the designated secure directory.
You can find the my.ini file in the C:\ProgramData\MySQL\MySQL Server 8.0 directory of a standard Windows 10 file system. | secure_file_priv | C:\ProgramData\MySQL\MySQL Server 8.0\Uploads\ | MySQL 8 installation on Windows 10 sets the following directory as the target for uploading files in the my.ini file: The MySQL FILE privilege is a global privilege to read and write files on the local server. They Windows 10 settings allowed for global sharing and both read and write privileges, but the LOAD command failed to load the file contents from the authorized Uploads directory. I checked and fixed all Windows 10 sharing and read-write privileges on the secure-file-priv designated directory.
Somehow, I think there should be some mention of how to resolve this error without unsetting the server-file-privy variable. While MySQL 5.7 contains the request for he server-file-priv variable, there is nothing in the MySQL System Server Variables document on how to troubleshoot the server-file-priv variable when set. The following covers my exploration to try and fix this error without removing a designated directory for secure file uploads. I think you’ll be seeing news on that front too.ERROR: 1290: The MySQL server is running with the -secure-file-priv option so it cannot execute this statement He’s also just started a gig doing hybrid application development for the iPod and iPhone. You can find more Mac, Ruby, and Django (a Python framework) tricks and techniques on his blog. I think he’ll make a great technology evangelist someday. My son just talked me into using Quicksilver, an application launcher – it’s great. I typically only run one virtual machine at a time because they’re allocated 2 GB of memory, and my MacBookPro only (my how life changes) supports 4 GB or memory. I’ve found Vista’s memory demands coupled with the Oracle 11g really requires 3 GB, and therefore a separate physical machine.
This affords me a great set of testing environments on a single machine.
The biggest difference is that my MacBookPro can run Mac OS X, Windows XP 圆4, Ubuntu, Red Hat 4 in virtual machines courtesy of VMWare Fusion. It different than the Apple 6 and Apple 7 that consumed me during my years at American President Lines in Oakland, California. While I’ve worked on many systems over the years, principally Windows for the desktop, and Linux and Unix for the servers, I’ve begun to return to Apple because of Mac OS X.