php and mysql

[Anon]

Hello.
I have a server with Red Hat 7.0. I install apache, php4, php4-mysql, mysql, mysql-server, mod_php, when I try to access with other pc to the database with an php-aplication, i have ploblems like that

Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) 

thank you for help me

[Anon]

Be sure You have an account both on your mysql server or your Linux (other or local pc) for mysql access. If you don't, create one on your linux for mysql user.

[Anon]

I have a account mysql, but all i install with root.

I install these rpm:

rpm -ivh php-4.0.1pl2-9.i386.rpm
rpm -ivh mod_php-4.0.1pl2-9.i386.rpm

restart apache

rpm -ivh mysql-3.23.22-6.i386.rpm
rpm -ivh mysql-server-3.23.22-6.i386.rpm

rpm -ivh php-mysql-4.0.1pl2-9.i386.rpm

and i have the same errors.

Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

Warning: Supplied argument is not a valid MySQL-Link resource in /var/www/html/Calendario/www/include//connection.php3 on line 301

thank you.

[brandonschnell]

1) make sure '/var/lib/mysql/mysql.sock' exists

2) make sure everyone has full access to the file ("chmod 777 /var/lib/mysql/mysql.sock")

3) make sure the user php is running as (nobody.nobody if its an apache module) has access to read the contents of the folder /var/lib/mysql/ ("chmod o+rx /var/lib/mysql/")

[Anon]

Thank you very much, the problems not are, now i can work with the aplication, but now i have others problems, when i programed the aplication i had php3 and mysql now i have php4, now the situation is the next:
some instructions fail:

MySQL: Fail in query: INSERT INTO ... VALUES (...)

The data are now in teh database but i don't know why i see the fail, other instructions fails update,i think the problems are when i try to write into database but i don't now where is the problems.

Thank you again.
Excuse for my english.

Brandon Schnell wrote:

1) make sure '/var/lib/mysql/mysql.sock' exists

2) make sure everyone has full access to the file ("chmod 777 /var/lib/mysql/mysql.sock")

3) make sure the user php is running as (nobody.nobody if its an apache module) has access to read the contents of the folder /var/lib/mysql/ ("chmod o+rx /var/lib/mysql/")

[brandonschnell]

run the php function "echo mysql_error();" right after the mysql_query function and post the full error messages.

[Anon]

I run the funtion mysql_error() but no show any message.

The code that i execute is like this:

$res = mysql_query($sql_query,$database);
if ($res==-1) error_message("MySQL: Fail in query: $sql_query");

When i insert or update $res is 1.
Perhaps it´s a problem of version.

Thank you