Hi. Try re-GRANTing the rights for user 'crash' and after you've done that, run 'flush PRIVILIGES'. Atleast on my winxp box it does the trick.
-Joni- -- // Joni Järvinen // [EMAIL PROTECTED] // http://www.reactorbox.org/~wandu "Gerard Samuel" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > 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
