INFILE file path
Hi everyone
I am using a free hosting service with:
1. a file web server to use with php
2. a database server with MySql 5.7
I am testing loading data from a temporal.txt csv file stored in a subfolder of the web directory
When I run the following statement:
LOAD DATA
INFILE 'temporal.txt'
INTO TABLE ... ;
from phpMyAdmin ... I get:
#1045 - Access denied for user '3941725_prueba'@'%' (using password: YES)
Mysql documentation says that the file must be located in the data folder of Mysql server installation
What do I need as a hosting user / service in order MySql get access to files hosted on the same hosting environment
Any comment that can help me?
Thank you in advance
AR
Subject
Written By
Posted
INFILE file path
September 29, 2021 09:16AM
September 29, 2021 10:19AM
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.