Can't connect to mysql

Anon

Hello,

I've written a PHP app running on win 2000 and connecting to mysql. I've moved the project to a linux server, but I always get message:

Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in /var/www/html/pcman/test.php on line 7

What's the problem? Mysql is up and running, and I can query from the console. It appears to be a port or socket problem. Any ideas?

Thanks in advance,

Jason

bruceg

Does the file /var/lib/mysql/mysql.sock exist? Is mysql running? If so, I would stop mysql, make sure that file does not exist, if it does, rm it, and restart mysql.

brandonschnell

http://www.xs4all.nl/~vinny/index.html#3

Anon

Thanks, but I tried everything you said and what the link said, but I still get the same error message. I installed mysql as part of the redhat install; would it help to install from source code? Here's the url of my script:

http://zephyr.camfilfarr.com/jason.php

thanks again.

bruceg

Well, if you tried everything, and it still did not work, then maybe there is a problem with your code. Can you post it, so we can take a look at it? For the record, I have MySQL 3.23.40 running on RH 7.1, which I d/l'ed from the MySQL.com site.

Anon

I will post the code in a bit, however, this is the exact same code I was using on Win2000/php4/mysql and I didn't have any problems.

Anon

Here's the code:

<body>

$db = mysql_connect("localhost","","");

mysql_select_db("mysql");

$sql = "select * from user";

$result = mysql_query($sql);

while ($row = mysql_fetch_array($result))
{

echo "$row[0] ----- $row[1]";

}
?>
</body>

bruceg

Hmm, are you leaving username/password out on purpose, or are you really not using a username/pass to access the db? I would highly recommend using a username/password.

What does your /etc/hosts file look like? Is there an entry for localhost? Is your lo interface up and running?

If the same code works on another machine with the same PHP/MySQL combo, I'd suspect something with your MySQL config, or how it is running. When you do a 'ps -ef|grep mysqld' do you see mysqld processes?

Is there anything in /var/lib/mysql like:
hostname.err hostname.pid? Look at hostname.err for clues as to why mysql might be failing.

bruceg

You also might want to try and interact with mysql if it is running, by doing a query from the command prompt:

#mysql -u root -p
Password:

mysql>use mysql
mysql>select * from user;

This should print out the usernames/encrypted passwords of the mysql users. If any of that fails, then you should suspect your mysql installation. If it works, then we need to look at how PHP was compiled with MySQL support.

I recommend grabbing the latest MySQL from mysql.com, and installing that. Then when rebuilding PHP from source, make sure to use the config option --with-mysql=/usr