i know this problem is well documented on this forum as well as virtually every other PHP/MySQL forum, but i've tried everything and nothing seems to help.
i can't seem to get PHP to connect to a MySQL database. it always throws the following error:
"Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock"
my call to mysql_connect looks like the following:
mysql_connect("localhost", "user", "password");
here is what i have tried to solve the problem:
the socket does exist at that location.
the MySQL server is running.
the socket, along with all of the directories it resides in, have adaquate access.
i can connect using the mysql client while specifying all of that same info (host, username, and password).
* the MySQL extensions to PHP are loaded and available.
here is the versions of what i'm using:
OpenBSD 3.2
Apache 1.3.26
PHP 4.2.3
MySQL 3.23.49
i've successfully used PHP and MySQL on a number of other machines (mostly FreeBSD or some variant of Linux), and i've never had a problem. this is my first time with OpenBSD, however. perhaps my problem is some specific detail in OpenBSD i'm unaware of???
any help would be GREATLY appreciated!
-ryan
