permission problem

[aa2000]

hi,
i have problem with writing to txt file
in mysql DB located in linux server
and it a permission problem which is

fopen("/text1.txt","w") - Permission denied in /dir/file.php
although connect to db as root with its password.
i want to say that the txt file is upload to
remote linux site with all necessary file
to same dir as the local system
so why it refuse to write to that text file
but it did in windows.

<?
$fp = fopen("/text1.txt", "wb");

while ($row = mysql_fetch_array ($rs)) {
$writefile = fwrite($fp, "$row["column1"]."|".$row["column2"]."\n"");
}
mysql_free_result ($rs);
?>

[bfranco]

did you know that apache (and of course php) runs as un unprivileged user??? (user "nobody", for example).

it doesn't matter what user you're login in as into the database (by the way, the backend runs as user mysql, or another unprivileged user).

why don't you try to save your files into a publicly writable directory???? something like:

$fp=fopen("/tmp/text1.txt", "wb");

you should not put files in your root directotory, it's a common practice to use small partitions for the /.

oh, another thing: the user that you're using to log in into the database, is an internal mysql user, it has nothing to do with the real root user.