as stupid as I normally am.....

From: Date: Wed, 24 Jan 2001 18:35:30 +0000
Subject: as stupid as I normally am.....
Groups: php.general 
Request: Send a blank email to php-general+get-36333@lists.php.net to get a copy of this message
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"

« previous php.general (#36333) next »