MySQL - separating web and database servers

From: Date: Thu, 18 Mar 2004 08:57:54 +0000
Subject: MySQL - separating web and database servers
Groups: php.db 
Request: Send a blank email to php-db+get-33494@lists.php.net to get a copy of this message
Hi everyone, I need to put my database server on the another machine - how can I configure system(Debian Linux)/php/mysql etc. to make it work without changing all 'localhost' in a hundreds of customer's scripts? The problem is, when localhost is specified as a host the connection is made using unix socket, not TCP (is it possible to change this?). I tried to export the socket from database server via NFS, but with no success: (...) munmap(0x2e1f2000, 4096) = 0 rt_sigaction(SIGPIPE, {SIG_IGN}, {SIG_DFL}, 8) = 0 socket(PF_UNIX, SOCK_STREAM, 0) = 3 fcntl64(3, F_GETFL) = 0x2 (flags O_RDWR) connect(3, {sin_family=AF_UNIX, path="/var/run/mysqld/mysqld.sock"}, 110) = -1 ECONNREFUSED (Connection refused) shutdown(3, 2 /* send and receive */) = 0 close(3) = 0 (...) Any ideas? Regards Piotr Babula

« previous php.db (#33494) next »