MySQL fails after upgrade to 4.2.0

[Anon]

I installed the new PHP 4.2.0 over 4.1.2 with same configuration parameters as with 4.1.2 (/configure --with-mysql --with-apxs=/usr/local/apache/bin/apxs)and it compiles and installs without any warnings. I'm running Apache Apache 1.3.24. Now when I try to run my old .php scripts that had MySQL-functions refuse to work. It simply says: "Can't connect to MySQL server on 'localhost'". This is odd, because I checked that the sock-file is correct in php.ini and also phpinfo(); reveals that MySQL support is loaded and the sock file points to a correct location. When I compile 4.1.2 with the same configure parameters it works. Anyone has a solution?

[Anon]

Noticed an interesting thing about the output of phpinfo(); It contains two parameters for the MySQL socket.

MYSQL_SOCKET: /var/lib/mysql/mysql.sock
mysql.default_socket: /tmp/mysql.sock

I forced the seconectparameter in php.ini but what is that first parameter that points to a non-existent sock file, which may cause this problem?

[Anon]

I've the same problem!
I've changed localhost to my hostname and it works!
but I'd rather use localhost,
plz write me the solution.

Blob wrote:

Noticed an interesting thing about the output of phpinfo(); It contains two parameters for the MySQL socket.

MYSQL_SOCKET: /var/lib/mysql/mysql.sock
mysql.default_socket: /tmp/mysql.sock

I forced the seconectparameter in php.ini but what is that first parameter that points to a non-existent sock file, which may cause this problem?