Re: 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 jacky@activelifestyle.com "There is nothing more rewarding than reaching the goal you set for yourself" ----- Original Message ----- From: Samantha Savvakis <samantha@cfs.net.au> To: Jacky@lilst <jacky@activelifestyle.com> 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:jacky@activelifestyle.com] > > Sent: Thursday, 25 January 2001 05:23 > > To: samantha@cfs.net.au; php-general@lists.php.net > > 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 > > jacky@activelifestyle.com > > "There is nothing more rewarding than reaching the goal you set for > > yourself" > > ----- Original Message ----- > > From: Samantha Savvakis <samantha@cfs.net.au> > > To: Jacky@lilst <jacky@activelifestyle.com>; <php-general@lists.php.net> > > 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:jacky@activelifestyle.com] > > > > Sent: Thursday, 25 January 2001 04:36 > > > > To: php-general@lists.php.net > > > > 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 > > > > jacky@activelifestyle.com > > > > "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: php-general-unsubscribe@lists.php.net > > > For additional commands, e-mail: php-general-help@lists.php.net > > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > > > > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > > For additional commands, e-mail: php-general-help@lists.php.net > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > >