Hi, (sorry for top-posting) This is the great way PHP-cli lets you know it hasn't got any MySQL support :) Enable that, and you're good to go. Mind you, PHP-cli has a separate php.ini file. Ivo On Thu, 28 Sep 2006 08:26:13 -0400, blackwater dev wrote: > Ok, I've set up a username and password using Grant All Privileges, blah. > with username and password. For some reason though the web now can't login > with that. I then changed the root db password and put that in the config > and the web side does run properly with that username, password. I still > can't run the script from the command line even when I su to root. I am in > a virtual hosting situation so not sure if that's it. Does it not know what > to do with localhost in a virtual hosting situation when running it from the > command line but does from the web? I'm trying to print the error but it > just seems to die: > > echo "about to connect"; > $this->connectionID= @mysql_connect($this->host, $this->user, > $this->password); > echo "after connect"; > > From the command line, it never prints the after connect...just seems to die > without error...or at least no error to the screen and I do have a check > right after to kick off the mysql error if there is no connection ID but > again, I am su'ing to root so I thought it would always have rights. Not > really sure what to do next. > > Thanks! > > On 9/27/06, Richard Lynch <ceo@xxxxxxxxx> wrote: >> >> On Wed, September 27, 2006 11:36 am, blackwater dev wrote: >> > I have some code that makes a connection to the db. When I run this >> > code >> > from the command line, it stops at the db connection. >> >> Show us the code, without any embedded passwords, of course... >> >> >> > If I call the >> > script >> > from the browser, it works fine. >> >> This almost always boils down to: >> PHP runs as "nobody" or a similarly unpowered user >> You log in as you, blackwaterdev or whatever, with many powers. >> >> In this case, it looks like 'nobody' has their own database, and is >> allowed to connect to it, but you are not. >> >> > I've changed the permissions and >> > that >> > didn't work. >> >> Changed which permissions? >> >> mysql_admin? >> If so, did you reload the permissions after change? >> >> File executable? >> >> What? >> >> > The db connection is the basic, localhost, root, with no >> > password. >> >> Now that is an entirely separate problem. >> >> DON'T DO THAT! >> >> :-) >> >> > What else can I try? >> >> You're going to have to create a user and set a password anyway, so do >> that first. >> >> There's no point in getting localhost/root/[blank] to work when it's >> not what you want anyway. >> >> -- >> Like Music? >> http://l-i-e.com/artists.htm >> >> >> -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
