MYSQL won't let me connect from PHP script

Sail@ · #1 7th October 2004, 03:55 PM

I've written a small script that connects to a mysql database (localhost) and adds some data into a table.

Now when i execute it i get the following error from the script:

Code:

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)

I know that the mysql.sock is located at that place in my system and I've also connected from the console, everything works.

Code:

[teddy@pr0nstar mysql]$ mysql -u thai -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 17 to server version: 3.23.58-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

I've tried executing the script from the console with "php -f test.php" and everything runs fine, all data gets added into the database.

Maybe it's got something to do with Apache, I don't know what to do...

***ewdi*** · #2 7th October 2004, 04:10 PM

can you post your code?

Sail@ · #3 7th October 2004, 04:38 PM

PHP Code:


			
<HTML>

<?php

        $namn = "Mysqltestdata";

        $medd = "OWNAGE!";

        print "MYSQL QUERY: <BR>";

        $myconn = mysql_connect('localhost', 'thai', 'password')

                or die("Could not connect to MYSQL Server.<BR>" . mysql_error());

        mysql_select_db("thailand")

                or die("Could not select database.");

        $laggtill = "INSERT INTO test (namn, medd) VALUES ('$namn', '$medd')";

        mysql_query($laggtill)

                or die("Could not add information.");

        mysql_close($myconn);

        print "Still alive?";

?>

</HTML>

This is EXACTLY what the script prints when called from the web http://127.0.0.1/test.php :

Code:

MYSQL QUERY: 
Could not connect to MYSQL Server.
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)

When using commandline "php -f test.php" I get this:

Code:

[root@pr0nstar html]# php -f test.php
<HTML>
MYSQL QUERY: <BR>Still alive?</HTML>

gablaxian · #4 7th October 2004, 05:20 PM

did you build either php, or mysql youself?

Sail@ · #5 7th October 2004, 05:25 PM

Nope, I used yum to install everything.

***ewdi*** · #6 7th October 2004, 05:28 PM

is php-mysql installed? or php-DBD at least

Sail@ · #7 7th October 2004, 06:11 PM

yep, php-mysql is installed.
the funtion mysql_connect() exists.
I don't have a clue

triplehead · #8 8th October 2004, 04:36 AM

is mysqld service on

Code:

chkconfig --list mysqld

Sail@ · #9 9th October 2004, 09:38 AM

It's activated only in / for runlevel 3.
That's the way it's supposed to be, right?

I'm gonna remove apache, php and mysql and reinstall them. Maybe it's just a version conflict? Anyway, I'll be back telling you the outcome of all this.

Sail@ · #10 9th October 2004, 10:51 AM

Okay, I've reinstalled the packages.
Still the same problem :/

Code:

MYSQL QUERY:
Could not connect to MYSQL Server.
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)

ieuuk · #11 9th October 2004, 11:43 PM

do you know if it put mysql.sock back to how it was originally?

Sail@ · #12 10th October 2004, 05:14 PM

Problem solved! (almost :P)

Screw mysql.sock, I now connect through tcp instead

An ugly solution, but I don't have the time / brains to fiddle with this anymore.
Thanks for all the help!

triplehead · #13 15th October 2004, 10:41 PM

still, what this gives you

Code:

chkconfig --list mysqld

Kalle · #14 16th October 2004, 01:46 AM

Hi people!

I used to have the same problem, but the solution was quite obvious

. Take a look at this: http://forums.devarticles.com/archive/t-4635

Cheers,

Kalle!