Mysql Connection failed: can't connect to local Mysql Server!!!!!

**tonyhams** · Mar 12, 2001 13:52

Iam running this little script to connect to the msyql server but i keep getting this error MySQL connection failed: Can't Connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in /var/www/html/index1.php on line 8

Unable to connect to the server.

<html>
<head>
<title> sign up page</title>
<head>
<body>
<?php

$dbcnx = mysql_connect("localhost","root","fuzzy");
if (!$dbcnx) {
echo ( "<P>Unable to connect to the server.</P>");
exit();
}

if (! @mysql_select_db("signup[") ) {
echo( "<P>Unable to locate sign up.</P>" );
exit();
}
?>

**Son Nguyen** · Mar 12, 2001 17:17

There is a problem with the MySQL server, restart it. Also, there are quite a few threads related to this problem, search on SPF and you'll see.

**tonyhams** · Mar 12, 2001 18:40

i restarted mysql and stoped and restarted and it still doesn't work. Ive tried everything mentioned in the forums and it still doesn't work. Any help would be welcomed.

**Kevin Yank** · Mar 13, 2001 19:33

Are you able to access your MySQL server using the command-line 'mysql' program?

**tonyhams** · Mar 14, 2001 14:26

yes i can do all the command from the commmand line.

**vaiod** · Mar 14, 2001 15:49

Does it make a difference if you place the IP of your server rather than localhost. I don't use localhost but rather the IP.

**tonyhams** · Mar 14, 2001 22:04

Using the servers ip doesn't work either
i just reinstalled redhat 7 with all packages and i still get that error.

**exbabylon** · Mar 15, 2001 00:22

try this code and see if it works...

PHP Code:


$dbcnx = mysql_connect("localhost","root","fuzzy"); 

if (!$dbcnx) { 

echo ( "<P>Unable to connect to the server.</P>"); 

exit(); 

} 



if (! @mysql_select_db("signup") ) { 

echo( "<P>Unable to locate sign up.</P>" ); 

exit(); 

}

change the appropriet items and try again... you had ab error with a extra bracket ([) where it ought not to have been.

hope this cures it.. seems you've been through a lot for such a little thing!

**freakysid** · Mar 15, 2001 00:44

exbabylon, that error is well spotted! However, the error is occurring during the call to mysql_connect() (line 8).

I believe the problem lies in the use of the password "fuzzy" which invokes the Apache fuzzy-logic module which is incompatible with mysql server

Seriously though...

1) Try using this address "127.0.0.1" intead of local host.

2) I'm thinking there also might be a problem with the sockets being used. Isn't the default socket for mysql server 3306 ??? But now I'm talking about stuff I don't really know about

**exbabylon** · Mar 15, 2001 01:10

ya... just correct your code... localhost SHOULD work...

**freakysid** · Mar 15, 2001 02:03

OK then - well, I just looked over my php database connection script that I use on my local linux box. (forgot what was in there because I just always include() it in my php files). It uses the machine's IP address on my LAN "10.0.0.77". If I change the address of the server to "localhost" I can't connect to mysql server either. Same problem with "127.0.0.1" - so my earlier suggestion fails too.

However, at least I can connect to the mysql server using the machine's IP address. tonyhams can't even do that.

**exbabylon** · Mar 15, 2001 02:11

if he was using the corrupt sript then it WOULDN'T connect no matter what settings he used... but freakysid, you are on a network.. it sounds as though he's on one machine.. so IP shouldn't be requirement... should it? Oh well... mabey... let us know when you get it working.. or not as the case may be... now I'm interested!

**freakysid** · Mar 15, 2001 02:21

I'm a complete idiot! I didn't have the mysql server running when I tested "localhost"

"localhost"
"127.0.0.1"
and the machines network address all work!

**James** · Mar 15, 2001 02:23

Try this:

PHP Code:


$dbcnx = mysql_connect("localhost:3306","root","fuzzy"); 

if (!$dbcnx) { 

echo ( "<P>Unable to connect to the server.</P>"); 

exit(); 

} 



if (! @mysql_select_db("signup") ) { 

echo( "<P>Unable to locate sign up.</P>" ); 

exit(); 

}

Have any settings like the Port been chcanged at all?

**vaiod** · Mar 15, 2001 11:35

Check your /etc/services file to be sure that the proper port is assigned for mysql. Also freakysid could be right with the password issue. I have had issues similar to this in the past.

User Tag List

Thread: Mysql Connection failed: can't connect to local Mysql Server!!!!!

Thread Tools

Display

Bookmarks

Bookmarks

Posting Permissions