PHP can't connect with mysql database

Anon

Hi,

I used to set up PHP4, apache 1.3.19 and mysql for web-based database. Last week I tried to install one program, but made my web server(apache)down, so I reconfigured apached using same way, then httpd started working. But my PHP couldn't connect to my mysql database, but used to work fine. Then I reconfigured PHP like

./configure --with-mysql=/usr/local/mysql --with-apache=/usr/local/apache_1.3.19 --enable-tract-vars

then make and make install, all steps looked like fine. My "test.php" works too. but I still got errors when I tried to retrieved data like

"Warning: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) in /mnt/disk1/blast/searcharray.php on line 9
Couldnt connect database"

I don't know where is problem. Appreciate your help.

Anon

Search the forum, this has been asked and answered hundreds of times.

Anon

Greetings, Vincent.

I, too, am having a somewhat different but similar problem.

However, your kind and thoughtful response to search the database resulted (for the last 3 days) in this:

"There was an error executing this query. Please try later."

Some of us are trying very hard.

P.S. If you have experience connecting to a remote MS-SQL Server, I would be very much in your debt to learn how to do this. Thanks!

[deleted]

for the mysql, try www.xs4all.nl/~vinny

for Ms-SQL, try http://www.phpbuilder.com/columns/alberto20000919.php3

Anon

Hi Vincent,

Thanks a lot, I already corrected it. In fact, after I roboot my server, I have to restart mysql, that was why I can't connect database.