I always use mysql_setpermission, which is a script for easy adding of users
and permissions etc. step by step. It comes with the standard dist. of
mysql.
Mvh Jørg
----- Original Message -----
From: "Jacky@lilst" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 24, 2001 10:45 PM
Subject: [PHP] db connection error: need help badly
> Quoting from my previous message. I think my exact question is that when I
> add a new db on to db server, How do I set up username and password to
> access that db? All I did was just run the query at "mysql" database to
> insert Host, username at "user" table ( left password blank)and gave all
> privileges as Y. And insert Host, User at "db" table with Y privileges as
> well.
> And what I added to the Host field on both tables is 216.122.146.146 (
which
> is the same IP susing at the code to establish db connection below.). But
> the IP for my db server is 216.122.146.147.
> Then I write "mysqladmin reload " .
> It still did not work. Somone told me that what added into the host
field
> on bothe table ( db and user) should be where I connect from, which in
this
> case should be 216.122.146.146, not the other IP, And the host IP in the
db
> connection sniplet should be the same too, right?
> So is there anything I miss here?
> error mesage:
> ********************
> Warning: MySQL Connection Failed: Access denied for user:
> '[EMAIL PROTECTED]' (Using password: NO) in
> /home/sites/site1/web/FreeSale/submitagree.php3 on line 2
> *****************************
> The sniplet is :
>
> $connection = mysql_connect("216.122.146.146", "freesale", "");
> ****************************************
> Jack
> [EMAIL PROTECTED]
> "There is nothing more rewarding than reaching the goal you set for
> yourself"
> ----- Original Message -----
> From: Maxim Maletsky <[EMAIL PROTECTED]>
> To: 'Jacky@lilst' <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Wednesday, January 24, 2001 2:06 AM
> Subject: RE: [PHP] db connection error
>
>
> > It says that the username or password are incorrect.
> >
> > Just Double Check them!
> >
> > Cheers,
> > Maxim Maletsky
> >
> > -----Original Message-----
> > From: Jacky@lilst [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, January 25, 2001 6:07 AM
> > To: [EMAIL PROTECTED]
> > Subject: [PHP] db connection error
> >
> >
> > Hi all,
> > I got the error below when I tried to establish db coonection.
> >
> > Warning: MySQL Connection Failed: Access denied for user:
> > '[EMAIL PROTECTED]' (Using password: YES) in
> > /home/sites/site1/web/FreeSale/submitagree.php3 on line 2
> >
> >
> > The sniplet is :
> >
> > $connection = mysql_connect("216.122.146.146", "freesale", "secret");
> >
> > what is the problem here?
> > 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]
