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]

Reply via email to