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 Jrg
- 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]
