Please forgive me, but Im more versed in FreeBSD than winXP.
WinXP is on my laptop for dev purposes.
When I installed mysql, I created a database and user with the name
'crash' via the command line client like so....
--------------
grant insert, delete, update, select, create, alter, drop on crash.* to
crash@localhost identified by 'crash';
--------------
And as far as I know, as long as the php script has the correct database
credentials, it should do what it needs to do. Well on my FreeBSD box
that is. But Im not sure if additional configurations are in order for
winXP.
Any guidance would be appreciated...
Thx
Miles Thompson wrote:
> Gerard,
>
> This is a shot in the dark, but does the web server (usually NOBODY,
> but "crash" in this case? Ominous name!) have an account on the XP box
> and the appropriate permissions to write to the MySQL database? That's
> where I'd start, along with checking mysql_error().
>
> Miles
>
>
> At 04:18 PM 8/18/2002 -0400, Gerard Samuel wrote:
>
>> Im trying to solve a problem with windows xp.
>> I have 2 identical scripts with the same db schema. One on FreeBSD
>> running php 4.2.2/mysql 3.23.49 & the other
>> on windows xp php 4.2.2/mysql 3.23.52.
>>
>> The section of the script is supposed to update a table.
>> ------
>> $sql = "UPDATE users SET email='$email' WHERE uid='$uid'";
>> $result = mysql_query($sql);
>> var_dump($result);
>> if (!$result)
>> {
>> die(mysql_error());
>> }
>> ------
>>
>> On the FreeBSD box, $result returns true, but returns false on the
>> windows box.
>> The error reported when it was false was "Access denied for user:
>> 'crash@localhost' to database 'crash'"
>> But according to that error, the connection parameters are correct.
>> I echoed $sql and ran the output of that in the mysql client, and it
>> executed successfully on the windows box.
>> So Im stuck as to what could be causing the error with the windows box.
>>
>> Anyone experienced this behaviour before???
>> Thx.
>>
>> --
>> Gerard Samuel
>> http://www.trini0.org:81/
>> http://dev.trini0.org:81/
>>
>>
>>
>> --
>> PHP Database Mailing List (http://www.php.net/)
>> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>
>
--
Gerard Samuel
http://www.trini0.org:81/
http://dev.trini0.org:81/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
