Unable to connect to MySQL

Sentosa

Hi!!

I've finished coding php, run it OK with my localhost and uploaded to my Apache server with Linux OS. However, I'm seemingly unable to connect to mysql at the server side... and received the following message:

Could not connect to database: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)

What's this message abt? I tried to get into MySQL without php on the server.. and received the same message at the console... how come?

Thanks to anyone who can help!

Sentosa

Hi!!

Could not connect to database: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)

What's this message abt? I tried to get into MySQL without php on the server.. and received the same message at the console... how come?

Thanks to anyone who can help!

olaf

please post us the code...

Sentosa

Thanks Olaf!! But I've tested things fine on localhost.. the code i used to connect is as below

define ('DB_USER', 'root');
define ('DB_PASSWORD', '');
define ('DB_HOST', 'localhost');
define ('DB_NAME', 'test');

$dbc=@mysql_connect (DB_HOST, DB_USER, DB_PASSWORD) or die ('Could not connect to database: '. mysql_error());
mysql_select_db (DB_NAME) or die ('Could not select the database: '. mysql_error());

regards.

olaf

try

define ('DB_HOST', 'localhost.localdomain');

Houdini

Copy and run the below code, since this is a new install with MySQL the program should work.

<html>
<head>
<title>Test MySQL</title>
<body>
<!-- mysql_up.php -->
<?php
$host="localhost";
$user="root";
$pass="";
mysql_connect($host,$user,$pass);
$sql="show status";
$result=mysql_query($sql);
if($result==0)
  echo("<b>Error ".mysql_errno().":" . mysql_error() ."</b>"); 
elseif(mysql_num_rows($result)==0)
  echo("<b>Query executed sucessfully!</b>");
else{
?>
<!-- Table that displays the results -->
<table border ="1">
  <tr><td><b>Variable name</b></td><td><b>Value</b></td></tr>
  <?php
    for($i=0;$i < mysql_num_rows($result);$i++){
	  echo("<tr>");
	  $row_array = mysql_fetch_row($result);
	  for($j=0;$j < mysql_num_fields($result); $j++){
	    echo("<td>".$row_array[$j]."</td>");
	}
	echo("</tr>");
  } 
?>
</table>
<?php
} 
?>
</body>
</html>

The above should print a large long table with all kinds of things about your MySQL server.

Houdini

You also asked this question in the Database Forum see this POST
Run that code to be sure that you are connecting, if successful it will print out a long table about your MySQL install provided that your PHP actually is working and that your MySQL is also installed properly. The code shown is tested and works if the above conditions are met.

Sentosa

Oki thanks.. I'll go try it when i get back to school tomorro.. thanks alot!!

Sentosa

Hi!!

Tried the code.. and the same error message occurs!! Oh my.. now MySQL is not workin... do I need to reinstall MySQL then? oops... :S But thanks Houdini!!! 🙂

Sentosa

Sighz.. the code din work.. do I have to reinstall MySQL then? :S

olaf

Sentosa wrote:
Sighz.. the code din work.. do I have to reinstall MySQL then? :S

do you tried the diff. host address?

lpxxfaintxx

It's your server, their mysql is temporarily down. Wait a day or two and you probably could start again.

lpxxfaintxx

It's your server.