as stupid as I normally am.....
| From: | Jacky@lilst | 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"