Gerard,
No need for an apology, but what permissions do you have set on the FreeBSD
box? Quite frankly I'd have to haul out all the stuff on MySQL security and
re-read it. Maybe that would be a good place to start, particularly if
there are different methods/base requirements for XP and BSD. (I also work
with Linux and Windows, so concepts tend to "haze over" from time to time
between systems.)
Is there an account for "crash" on the XP box? An account for the web
server? Again, not in MySQL, but in XP. I have a hunch that when you are
using the mysql console on the XP box you have administrator rights, thus
everything works.
Cheers - Miles
At 09:36 AM 8/19/2002 -0400, Gerard Samuel wrote:
>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
