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]
