I might have missed the first of your posts and may be repeating someone
else's suggestions but have you checked the hosts that the mysql user
account that your are using can connect from the right areas. In the
user table of the mysql database insure that the user account you are
using has the proper rights to connect from 'localhost' and depending on
your setup, that user may need access to connect from
'localhost.localdomain'. You could test if this may be the problem by
giving that user account the value of '%' in the host column which would
allow the user to connect from all hosts but do not leave it this way as
you will be wide open for intrusion.
BJH
-Original Message-
From: David Robley [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 05, 2002 8:27 PM
To: Bryan McLemore; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Re: mysql_connect
On 3 Sep 2002 at 23:00, Bryan McLemore wrote:
- Original Message -
From: David Robley [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, September 03, 2002 9:31 PM
Subject: [PHP-DB] Re: mysql_connect
In article 000c01c253b2$506d7530$0101a8c0@fwcmain,
[EMAIL PROTECTED] says...
I'm trying to connect using the sample code in the php
documentation.
IT however dies every time. If someone could please help me? Thanks.
BryanCan you show the code you are using, and any error
messages you get? -- David Robley Temporary Kiwi! Quod
subigo farinam -- PHP Database Mailing List
(http://www.php.net/) To unsubscribe, visit:
http://www.php.net/unsub.php
Love the formatting by your mail pkg - OE of course :-)
The code is
$link = mysql_connect(localhost:3306, UserName, Password)
or die(Could not connect);
Thanks,
Bryan McLemore
May I suggest you keep the discussion on the mailing list - a) you have
the entire list's expertise to draw on, b) the solution is shared with
others who may benefit and c) you may get a quicker answer.
Now, you haven't said so, but I assume you are getting 'Could not
connect'?
So, points to check:
1) mysql is running, and on port 3306; note that you don't need to
specify the port usually
2) the username and password are correct - try the command line version
to check that the user/pass are accepted (assuming you have command line
access)
3) remove the 'or die' construct and see if you get an error message
--
David Robley
Temporary Kiwi!
Quod subigo farinam
My grape juice has fermented, Tom whined.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
