Just a note for others who went through what I did, and a note of thanks. Regranting and flushing privileges, make everything run smooth for me. :)
Joni Järvinen wrote: >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/ >> >> >> >> >> > > > > > -- 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
