MySQL Forums
Forum List  »  PHP

INFILE file path
Posted by: Alvaro Rondon
Date: September 29, 2021 09:16AM

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

Options: ReplyQuote


Subject
Written By
Posted
INFILE file path
September 29, 2021 09:16AM
September 29, 2021 10:19AM


Sorry, only registered users may post in this forum.

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.