This is not for PHPMyAdmin. I want to load some data into SQL using
my PHP script.
LOAD DATA LOCAL won't work in the current versions of MySQL.
It is patched due to some security issues.
MySQL manual says that we have to use LOAD DATA instead.
When I try LOAD DATA command, I get an Access Denied error.
"Access denied for user: 'my_dbusr@localhost' (Using password: YES)"
Quote:
|
If you are able to connect to the MySQL server, but get an Access denied message whenever you issue a SELECT ... INTO OUTFILE or LOAD DATA INFILE statement, your entry in the user table doesn't have the FILE privilege enabled.
|
Unfortunately, CPanel is not having FILE privilege option while creating the usernames and granting privileges for the mysql databases.
Help is appreciated. |
