Justtechjobs.com Find a programming school near you






Online Campus Both


php3-list | 200003

Re: RE: [PHP3] mysql_connect problem From: Aaron Grewell (agrewell <email protected>)
Date: 03/01/00

That was it all right. It didn't do that on the old machine, so I must've configured either MySQL
or httpd differently. Hmmm... Anyway, thank you all very much. Support listservs are the best!

>>> Cynic <cynic <email protected>> 03/01 9:31 AM >>>
you said you can connect to mysqld using mysql client.
are the server and the client on the same machine?
is the web server on the same machine? what do you
provide in your script as the hostname? is it 'localhost'?
if not, that might be the problem. check mysql permissions.
you might find out the user in your script can connect
only from localhost.

btw, i don't know whether you're running an *ix or win32,
there might be a lot of different issues on linux or *bsd.

At 09:09 1.3.2000 -0800, Aaron Grewell wrote the following:
--------------------------------------------------------------
I guess I had my error checking set up wrong. Anyway, now it says:
"Warning: MySQL Connection Failed: Can't connect to MySQL server on 'www.pierce.ctc.edu' (113)"

I've doublechecked the hostname, port number, userid, and password. All work fine with the MySQL
client. What else can I try?

>>> "Henry F. Marquardt" <hank <email protected>> 02/29 5:06 PM >>>

-----Original Message-----
From: Henry F. Marquardt [mailto:hank <email protected>]
Sent: Tuesday, February 29, 2000 7:01 PM
To: Aaron Grewell
Subject: RE: [PHP3] mysql_connect problem

Hmm,

One statement bothers me ... "It doesn't give me errors, it just doesn't
connect" ... do you *know* it isn't giving an error?

if(!($link=mysql_connect($host,$user,$pass))) {
        printf("Error %d:%s",mysql_errno($link),mysql_error($link));
        }

If you answered no .... run it again with this kind of error checking. If
yes, then you are connecting and you have some other problem ... db
selection or query problems.

Please clarify.

Hank

-----Original Message-----
From: Aaron Grewell [mailto:agrewell <email protected>]
Sent: Tuesday, February 29, 2000 6:32 PM
To: php3 <email protected>
Subject: [PHP3] mysql_connect problem

Like a number of folks I've seen here, I'm trying to get PHP and MySQL
working together. I compiled
PHP as a DSO with MySQL support, and the PHP part works fine. The problem
is that when I call
mysql_connect I can't connect. I have verified that the userid and password
work fine with the
mysql client, just not with PHP. Where is the best place to start
troubleshooting this thing? It
doesn't give me errors, just doesn't connect.

------end of quote------
____________________________________________________________
Cynic:

A member of a group of ancient Greek philosophers who taught
that virtue constitutes happiness and that self control is
the essential part of virtue.

<mailto:cynic <email protected>>cynic<mailto:cynic <email protected>> <email protected>
ICQ: 2808 2505 

-- 
PHP 3 Mailing List <http://www.php.net/>
To unsubscribe, send an empty message to php3-unsubscribe <email protected>
To subscribe to the digest, e-mail: php3-digest-subscribe <email protected>
To search the mailing list archive, go to: http://www.php.net/mailsearch.php3
To contact the list administrators, e-mail: php-list-admin <email protected>