Re: [PHP] strange errors from command line vs. web
- From: ceo@xxxxxxxxx ("Richard Lynch")
- Date: Thu, 28 Sep 2006 11:33:41 -0500 (CDT)
On Thu, September 28, 2006 7:26 am, 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.
su root or not does *nothing* to help you run MySQL and do database
things.
MySQL has a user called 'root' but it's not in any way, shape, or form
related to the OS 'root'.
Well, okay, the *idea* is the same, and the *name* is the same... But
that's it!
The *only* thing that matters to MySQL is the username/password used
to connect, and what permissions have been granted in MySQL to that
username/password.
echo "about to connect";
$this->connectionID= @mysql_connect($this->host, $this->user,
$this->password);
echo "after connect";
Get rid of the @, at least until you figure out what is going on.
again, I am su'ing to root so I thought it would always have rights.
Don't bother su-ing to root. It has no effect on MySQL whatsoever.
--
Like Music?
http://l-i-e.com/artists.htm
.
- References:
- strange errors from command line vs. web
- From: "blackwater dev"
- Re: [PHP] strange errors from command line vs. web
- From: "Richard Lynch"
- Re: [PHP] strange errors from command line vs. web
- From: "blackwater dev"
- strange errors from command line vs. web
- Prev by Date: RE: [PHP] Best open source project/framework to support a php training course?
- Next by Date: Re: [PHP] strange errors from command line vs. web
- Previous by thread: Re: [PHP] strange errors from command line vs. web
- Next by thread: LAMP benchmarking tool
- Index(es):
Relevant Pages
|
