How do I look in to mysql log files? Anyway, the IP 216.122.146.147 is the
IP of db server where the page tries connect to (and my developing machine
is on ISDN line and the ip is 192.168.0.100 in which I think it does not
quite relevant to bring it up here) . But The actual IP of the server that
host the php files is 216.122.146.146 .
But when I looked at other username and password that has set up on other
PHP project, at the host field of both "user" table and "db" table, it use
216.122.146.147 and the application is working fine with the same sniplet
for db connection.
cheers
Jack
[EMAIL PROTECTED]
"There is nothing more rewarding than reaching the goal you set for
yourself"
----- Original Message -----
From: Samantha Savvakis <[EMAIL PROTECTED]>
To: Jacky@lilst <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, January 24, 2001 12:56 AM
Subject: RE: [PHP] as stupid as I normally am..... ( Nope!)
> When you insert into the user table, the "Host" column is where you are
> connecting "FROM" not where you want to connect to.
>
> This could be something you have wrong. You want to connect to
> "216.122.146.147" ?? And you have inserted into the user table that you
are
> coming from 216.122.146.147. So, if I can make assumptions, the host where
> you are connecting from and where you want to connect to are on the same
> machine? You can just use "localhost" for that if that is the case.
>
> Have you looked in the mysql log files to see what errors it is giving or
a
> reason why this user can't connect?
>
> Other than that, you have taken the right steps to create a new db user,
and
> if you have done the reload, everything should work.
>
> > -----Original Message-----
> > From: Jacky@lilst [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, 25 January 2001 05:45
> > To: [EMAIL PROTECTED]
> > Cc: [EMAIL PROTECTED]
> > Subject: Re: [PHP] as stupid as I normally am..... ( Nope!)
> >
> >
> > Nope, it still not working after i refresh the page. I went to database
> > mysql again and check table "user" and see username "freesale" there
with
> > the host IP and it is empty at the password field in the table.
> > I also went to check table "db" and look at the fields Host, user
> > and I also
> > see correct Host IP together with username "freesale".
> > And the code to set up db connection at the page is below:
> > **********************************************
> > $connection = mysql_connect("216.122.146.147", "freesale", "") or die
> > ("Could not connect");
> > mysql_select_db("FreeSale", $connection);
> > ***********************************************
> > Please enlighten me what I have done wrong because I nearly went crazy
now
> > :-)
> > Jack
> > [EMAIL PROTECTED]
> > "There is nothing more rewarding than reaching the goal you set for
> > yourself"
> > ----- Original Message -----
> > From: Samantha Savvakis <[EMAIL PROTECTED]>
> > To: Jacky@lilst <[EMAIL PROTECTED]>
> > Sent: Wednesday, January 24, 2001 12:29 AM
> > Subject: RE: [PHP] as stupid as I normally am.....
> >
> >
> > > hi,
> > >
> > > ok, you did the reload, and now when you try your connect, does it
work?
> > >
> > > The reload command does not return anything.
> > >
> > > Sam
> > >
> > >
> > > > -----Original Message-----
> > > > From: Jacky@lilst [mailto:[EMAIL PROTECTED]]
> > > > Sent: Thursday, 25 January 2001 05:23
> > > > To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> > > > Subject: Re: [PHP] as stupid as I normally am.....
> > > >
> > > >
> > > > I did use "./mysqladmin reload" and I got this back on the
> > > > interface ( using
> > > > telnet)
> > > > **********************
> > > > mysql> ./mysqladmin reload
> > > > ->
> > > > *********************
> > > > and it does not do anything, is that mean the db serevr has
> > already been
> > > > reloaded?
> > > > cheers
> > > > Jack
> > > > [EMAIL PROTECTED]
> > > > "There is nothing more rewarding than reaching the goal you set for
> > > > yourself"
> > > > ----- Original Message -----
> > > > From: Samantha Savvakis <[EMAIL PROTECTED]>
> > > > To: Jacky@lilst <[EMAIL PROTECTED]>;
> > <[EMAIL PROTECTED]>
> > > > Sent: Tuesday, January 23, 2001 11:34 PM
> > > > Subject: RE: [PHP] as stupid as I normally am.....
> > > >
> > > >
> > > > > you are forgetting to do a reload.
> > > > >
> > > > > ./mysqladmin reload
> > > > >
> > > > > > -----Original Message-----
> > > > > > From: Jacky@lilst [mailto:[EMAIL PROTECTED]]
> > > > > > Sent: Thursday, 25 January 2001 04:36
> > > > > > To: [EMAIL PROTECTED]
> > > > > > Subject: [PHP] as stupid as I normally am.....
> > > > > >
> > > > > >
> > > > > > Hi people,
> > > > > > Off the topic here again but hope it won't be too much to ask.
As
> > > > > > inexperience person on setup new Db on Mysql for new php
project,
> > > > > > I need to add new database on Mysql for new project, as stupid
as
> > > > > > I normally am, I don't really know what exactly to do about the
> > > > > > set up of user and password on that new db after it is added. So
> > > > > > the db connection could not connect at the code.
> > > > > > What I did was that after I added new db, log in to Mysql admin
> > > > > > via telnet, say "use Mysql" database and add new user at "user"
> > > > > > table (without password,leave it blank), with this query:
> > > > > >
> > > > > > > insert into user values ('216.122.146.147','freesale',
> > > > > > '','y','y','y','y','y','y','y','y','y','y','y','y','y','y');
> > > > > >
> > > > > > and freesale is of course username and I left password field as
> > > > > > blank and given all previliges as yes.
> > > > > >
> > > > > > Then add that username into Db table together with the database
> > > > > > name using this query :
> > > > > >
> > > > > > >insert into db values
> > > > > >
('216.122.146.147','FreeSale','freesale','y','y','y','y','y','y','
> > > > > > y','y','y','y');
> > > > > >
> > > > > > while FreeSale is database name and freesale is username.
> > > > > >
> > > > > >
> > > > > > Database connection still could not establish, Anything
> > else I miss
> > > > here?
> > > > > > cheers
> > > > > > Jack
> > > > > > [EMAIL PROTECTED]
> > > > > > "There is nothing more rewarding than reaching the goal you set
> > > > > > for yourself"
> > > > > >
> > > > >
> > > > > --
> > > > > PHP General Mailing List (http://www.php.net/)
> > > > > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > > > > For additional commands, e-mail: [EMAIL PROTECTED]
> > > > > To contact the list administrators, e-mail:
> > [EMAIL PROTECTED]
> > > > >
> > > >
> > > >
> > > > --
> > > > PHP General Mailing List (http://www.php.net/)
> > > > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > > > For additional commands, e-mail: [EMAIL PROTECTED]
> > > > To contact the list administrators, e-mail:
> > [EMAIL PROTECTED]
> > > >
> > >
> >
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
