|
Posted by Bruce A. Julseth on 08/02/05 04:38
I have three users with access to my test MySQL databases, root plus two
others. The following PHP code only works when the user is root. Otherwise
it fails.
$File = addslashes(getcwd() . "\Address.txt");
$SQL = "Load Data InFile \"" . $File . "\" into table addresses";
$result = mysql_query($SQL) or die("Failed to load data");
Both users were created by root from a cmd prompt:
grant all on * to user@localhost identified by 'mypw' with grant options;
What is wrong so that the created users can execute the above code?
Thanks.
Bruce
Navigation:
[Reply to this message]
|