PHP and MySQL error

[jerox]

Hi, I get this error on PHP when I try to connect to MySQL server, any ideas?

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

I'm on FC3, with MYSQL:
mysql Ver 14.9 Distrib 5.0.3-beta, for pc-linux-gnu (i686),

The mysql server is running, as I'm connected to it on another terminal.

Thanks!

[komi]

Does the file
/var/lib/mysql/mysql.sock
exists when the sqlserver is running?

[jerox]

yes, it does:
srwxrwxrwx 1 mysql mysql 0 Aug 30 08:36 /var/lib/mysql/mysql.sock
I'm wonderig if ther's any place where I can look up for error (13) ?

[jerox]

I'm using this version of PHP, does it has to do anything with it?
[root@user-0vvdbsl html]# rpm -qa | grep php
php-ldap-4.3.9-2
php-odbc-4.3.9-2
php-4.3.9-2
php-pear-4.3.9-2
php-mysql-4.3.9-2
[

[komi]

maybe this can help you:
http://forums.devshed.com/showthread.php?t=14130

[cedid]

hello guys,

I am having a similar problem, i can't start mysqld, it gives me error :

/root > service mysqld start
Timeout error occurred trying to start MySQL Daemon.
Starting MySQL: [FAILED]
/root > cd /usr ; /usr/bin/safe_mysqld &
[1] 9748
/usr > Starting mysqld daemon with databases from /var/lib/mysql
050904 12:25:29 mysqld ended

[1]+ Done /usr/bin/safe_mysqld
/usr > service mysqld status
mysqld dead but subsys locked
/usr > service mysqld start
Timeout error occurred trying to start MySQL Daemon.
Starting MySQL: [FAILED]
/usr > mysql
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

/var/lib/mysql > ls -al
total 20564
drwxr-xr-x 4 mysql mysql 4096 Sep 4 12:31 .
drwxr-xr-x 22 root root 4096 Aug 24 05:41 ..
-rw-rw---- 1 mysql mysql 10485760 Aug 24 05:57 ibdata1
-rw-rw---- 1 mysql mysql 5242880 Aug 24 06:12 ib_logfile0
-rw-rw---- 1 mysql mysql 5242880 Aug 24 05:47 ib_logfile1
drwx------ 2 mysql mysql 4096 Aug 24 05:41 mysql
srwxrwxrwx 1 mysql mysql 0 Sep 4 12:31 mysql.sock
drwx------ 2 mysql mysql 4096 Aug 24 05:41 test

what am i missing, any suggestions ? PS. my SELinux is disabled

[smfinley]

Verify that your host in /etc/hosts and /etc/sysconfig/network agree with your host (domain) set up in MySQL and httpd. You may also have to disable SELinux for the httpd daemon. Also make sure that the httpd and mysqld daemons are configured to start as services automatically. See the web server and MySQL sections of FC4 Notes and FC3 Notes.

[cedid]

Originally Posted by smfinley

Verify that your host in /etc/hosts and /etc/sysconfig/network agree with your host (domain) set up in MySQL and httpd. You may also have to disable SELinux for the httpd daemon. Also make sure that the httpd and mysqld daemons are configured to start as services automatically. See the web server and MySQL sections of FC4 Notes and FC3 Notes.

I was going by those FC3 notes, but it didn't even start the mysqld service. I am not sure whether I did somewhere a mistake while I was playing around to configure it by myself. But I know I removed something, this was what i did before trying the instructions on your page :

/usr > rpm -e mysql-3.23.58-16

and it removed that package. Now when I type :

/usr > rpm -qa | grep mysql
mysql-debuginfo-3.23.58-16.FC3.1
mysql-devel-3.23.58-13
mysql-3.23.58-16.FC3.1
mysql-server-3.23.58-16.FC3.1
libdbi-dbd-mysql-0.6.5-9
mysql-devel-3.23.58-16.FC3.1
mysql-bench-3.23.58-16.FC3.1

As you see mysql-3.23.58-16 is not there anymore. Do you think that's causing the problem?

When I type :
/usr > mysql -u root
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

So, I can't apply the configuration instructions on your page...