connecting PHP 4.3.9 with mysql 3.23.58...

marty_600

Hiya all,

Hope you can help. If there is an exact FAQ on this somewhere pls feel free to point me to it!

I can't connect my PHP with MySQL, and its drving me nuts!

PHP is working ok - basic, basic web scripts working (Cookie creation ok etc...)
Mysql is working ok - can create databases at CMD line etc.

Installed Fedora Core 3. Basic web site running fine, except with using Mysql. I've left all the default setting alone...

Is there some config setting I need to do somewhere to get this to work???

I've done the same commands as I did on trainng course. No good. Went right back to basics, and its failing at 1st hurdle.

(Ie failing at connect...)

$dbh= mysql_connect("localhost","user","password");
if (!$dbh) echo "Failed to connect to MySQL server!";

Guess what? It prints the Error message above.

I hope you can help
Martin

PS:
Apache/2.0.52 (Fedora)
PHP 4.3.9
mysql 3.23.58...

thorpe

well we need to see what the mysql error is. let us know what this says.

$dbh= mysql_connect("localhost","user","password") or die(mysql_error());

marty_600

Hiya Thorpe,

Are... good point! (Just gpoing by what the manual said - for quick check points!)

The error I'm getting is:

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

I hope you can throw some light on this!

Cheers
Martin

thorpe

i think this means you havent setup the user tables.

you need to run this script.

/pathtomysql/mysql/bin/mysql_install_db

marty_600

hiya THorpe,

Ive found a copy of the script.

its under:
/usr/bin/mysql_install_db

What does it do though? (sorry no MAN pages on it etc...)

Is there any prereq info I need before running it?
Any Config work while running it?

Cheers
Martin

marty_600

I Found the Fix Guys!

Akk I did was
/usr/sbin/setenforce 0
/etc/init.d/mysql start

Something to do with mysql only allowing the user "mysql" to use it. Theabove, relaxs this restrictions, so all users can use Mysql...

Pls advise if not tech correct etc.

Martin

http://forums.mysql.com/read.php?11,20759,21482#msg-21482

Re: #2002 - Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)
Posted by: John Speerin (IP Logged)
Date: April 7, 2005 02:16PM

WOOT.....found a solution

SE linux makes it very hard for anything to work in Fedora Core 3.....(generalization)

When i was shutting the computer down i noticed that there was and error in removing the mysql.sock.....no permissions. I had monkeyed arround trying to find out what i need to give permissions too.....the i revisited my installation proceedure. I had origionally installed Fedora Core using Stanton-Finley notes. During the install it made a reference to turn off the protection for the httpd daemon. SO CLICK, the light bulb came on.

Uninstall mysql server and mysql-max
reinstall mysql server and mysql-max (gets rid of any errors that may have occurrd previous)

What you need to do is to go to terminal in root

/usr/sbin/setenforce 0
/etc/init.d/mysql start

This will force selinux off and start msql to get a mysql.sock started.

Go to Applications > System Settings > Security Level and type in your root pass word

Open the SELinux tab and under Modify SE linux policy
open SElinux service protection and click on Disable SELinux protection for mysqld daemon.

reboot your computer