MySQL Forums
Forum List  »  Newbie

Windows LOAD_FILE
Posted by: craig hamilton
Date: November 23, 2016 01:50AM

I'm having a problem with LOAD_FILE on windows 10. I've used:

mysql> select load_file("C:/build/svn/bjrlfcwebsite/images/male.jpg");

which results in NULL. My image is only 8192 bytes with max_allowed_packet set to 4194304, so that should not be the problem. My grants are as follows:

GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION
GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION

The file resides on my development machine along with the server and all users have full control of the file.

What am I doing wrong?

Thanks in advance.

Options: ReplyQuote


Subject
Written By
Posted
Windows LOAD_FILE
November 23, 2016 01:50AM
November 23, 2016 02:16AM
November 23, 2016 02:57AM
November 23, 2016 03:50AM
November 23, 2016 04:42AM
November 23, 2016 05:44AM
November 23, 2016 02:57PM
November 23, 2016 03:09PM
November 23, 2016 06:05PM
November 23, 2016 06:33PM
November 23, 2016 06:37PM
November 23, 2016 06:49PM
November 23, 2016 06:58PM
November 23, 2016 07:05PM
December 08, 2016 07:16PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.