Can't connect to MySQL using PHP

binnyva · 02-05-2006, 05:50 AM

Hi,

I have Fedora Core 3 with Apache, PHP and MySQL installed by default. I am tring to connect PHP with MySQL. But phpMyAdmin gives the error "#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)".

When I tried to connect using my own PHP codes, I got the error

Quote:

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

The code I used is

Quote:

//Connect to the database
mysql_connect("localhost","root",'') or die("Unable to connect to MySQL : " . mysql_error());

//Select the necessary Database
mysql_select_db('test') or die("Unable to select the database 'test' : " . mysql_error());

There is no problem with mysql. I can run the program using the 'mysql -u root -p <password>' command. In this shell I can access the databases and tables without any problem. But I cannot access the MySQL server from PHP.

Any help is greatly appriciated.

Binny V A

thermite_1033 · 02-05-2006, 08:46 AM

make sure apache can read the socket and the whole path to the socket
check your permisions

graemef · 02-05-2006, 10:59 AM

Can you connect via localhost?

dudulz · 02-05-2006, 11:54 AM

-- check php.ini /usr/local/lib/php.ini , after that check the compiling command. Make sure that compile command have option --with-mysql=$path.
-- if still still error check in local db store, check ownship (it must mysql). after that "./mysqld_safe --user=mysql &" (configuration in /etc/my.cnf)

-- try again "mysql -u root -p "

MicahCarrick · 02-05-2006, 03:06 PM

I get this error every time I reinstall my linux distro... and now I can't recall the solution. There are permissions and selinux issues if I recall, but I think for me I simply didn't have all the required packages. Make sure you have mysql, mysql-server, and php-mysql. I think my problem was that I had mysql and php-mysql but not mysql-server.

yum install php-mysql mysql mysql-server

binnyva · 02-08-2006, 12:11 PM

I have solved the problem - I disabled selinux.

Open /etc/selinux/config
Change the line
SELINUX=enforcing
TO
SELINUX=disabled
Then restart the system.

One doubt - how will this affect me? I know that selinux has something to with security - but not more than that. What is the the function of selinux? Will I run into any trouble by disabling it?

Security is not much of an issue for me - the system I am working on is connected to just another computer inside my home - no other network has access to it. Also the system will NOT be a internet web server. I need PHP/MySQL to test my programs at home - not for serving files over the net. So will there be a problem if I disable selinux?

Anyway, thanks for all your suggestions.

win32sux · 02-08-2006, 12:15 PM

Quote:

Originally Posted by binnyva

One doubt - how will this affect me? I know that selinux has something to with security - but not more than that. What is the the function of selinux? Will I run into any trouble by disabling it?

here's some info about it:

http://en.wikipedia.org/wiki/Selinux

http://fedora.redhat.com/docs/selinux-faq/

no, you won't run into trouble by not using it... it's just an aditional security option you can add to your linux systems to make them harder to crack...

Quote:

Security is not much of an issue for me - the system I am working on is connected to just another computer inside my home - no other network has access to it. Also the system will NOT be a internet web server. I need PHP/MySQL to test my programs at home - not for serving files over the net.

yeah, IMHO it sounds like you don't really have much use for selinux...

of course, when you finally do set the box up as an internet server then selinux is something you should at least consider learning to use, as it's a valuable tool when it comes to mission-critical linux installations...

just my

...

BongHongXanh · 02-08-2006, 10:08 PM

Quote:

Originally Posted by binnyva

Hi,

I have Fedora Core 3 with Apache, PHP and MySQL installed by default. I am tring to connect PHP with MySQL. But phpMyAdmin gives the error "#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)".

Binny V A

MySQl is not running
you must statup MySQL !

Command:
$chkconfig --add mysqld --level 345

win32sux · 02-09-2006, 06:37 AM

Quote:

Originally Posted by BongHongXanh

MySQl is not running
you must statup MySQL !

Command:
$chkconfig --add mysqld --level 345

he said he already fixed it by disabling selinux...

nonfatalexec · 05-12-2006, 10:11 PM

You can use SELinux properly by running

Code:

setsebool -P httpd_can_network_connect_db=1

The "P" will make this SELinux change persistent through your next reboot.

You can get the list of all SELinux booleans by running this command

Code:

getsebool -a