Re: Re: Mysql DB connect failure
| From: | ML | Date: | Fri, 21 Feb 2003 16:26:35 +0000 |
| Subject: | Re: Re: Mysql DB connect failure | ||
| References: | 1 2 3 4 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-136531@lists.php.net to get a copy of this message | ||
I see that its looking for mysql.sock in /tmp/mysql.sock
but I searched on my system and only found mysql.sock in /var/lib/mysql/
is there a section where I need to change this setting? or a conf file?
"Hans Prins" <HPrins@xgn.nu> wrote in message
news:20030221160720.4236.qmail@pb1.pair.com...
> > Would you care to explain to the rest of the list how you intend to use
> > mysql_error () to return connection failure information?
> >
> > It returns the text of the error message from previous MySQL operation
> > Description: string mysql_error ( [resource link_identifier])
> >
> > Seems to me that without a connection, we wouldn't have a valid
> > link_identifier.
>
> maybe so, but it works nonetheless.............
>
> if for example the username stated in the connection initialization was
> wrong it will print an error like:
>
> "Access denied for user: 'username@localhost' (Using password: YES)"
>
> MI,
>
> my code would look somethign like this:
>
> $link = @mysql_pconnect("localhost", "test1", "test1");
>
> // If connection failed...
> if (!$link) {
> // Inform user of error and quit
> print "Couldn't connect to database server<br>\n";
> print mysql_error();
> exit;
> }
>
>
>
> "Jason K Larson" <jlarson@candlefire.org> schreef in bericht
> news:3E564B92.4070703@candlefire.org...
> > Would you care to explain to the rest of the list how you intend to use
> > mysql_error () to return connection failure information?
> >
> > It returns the text of the error message from previous MySQL operation
> > Description: string mysql_error ( [resource link_identifier])
> >
> > Seems to me that without a connection, we wouldn't have a valid
> > link_identifier.
> >
> > What you probably should attempt going for is getting something back
> > from PHP itself regarding the error returned when the mysql_connect
> failed.
> >
> > Here's a snippet from:
> >
> > http://www.php.net/manual/en/language.operators.errorcontrol.php
> >
> > If the track_errors feature is enabled, any error message generated by
> > the expression will be saved in the global variable $php_errormsg. This
> > variable will be overwritten on each error, so check early if you want
> > to use it.
> >
> > Hope that clears things up a bit.
> >
> > Regards,
> > Jason k Larson
> >
> >
> >
> > Hans Prins wrote:
> > > did you try:
> > > print mysql_error();
> > >
> > > "Ml" <slickmik@eden.rutgers.edu> schreef in bericht
> > > news:20030221152240.57775.qmail@pb1.pair.com...
> > >
> >
> >
>
>