Re: [PHP-DB] PHP5-MySQL Not Connecting Through Socket

No Fen Lu, as I said in my first post, MySQL runs just fine and for some strange reason all other applications can connect through unix socket to the database except PHP scripts. But I solved the problem but chmod'ing the "directory" of the socket file rather the socket file itself. It had slipped

Re: [PHP-DB] PHP5-MySQL Not Connecting Through Socket

try #: mysqld for test? I think your mysql is not running~... I met this problem last night...hehe... On 9/2/05, Evan J <[EMAIL PROTECTED]> wrote: > > Ok, someone mentioned that I did not have an appropriate permission to > access mysql.sock directory. Guess what? He was right on the spot. So > fo

Re: [PHP-DB] PHP5-MySQL Not Connecting Through Socket

Ok, someone mentioned that I did not have an appropriate permission to access mysql.sock directory. Guess what? He was right on the spot. So for whomever who reads this, the solution proposed is to `chmod 755 /usr/local/mysql/tmp' Thanks to that individual who assisted me on this. On 9/2/05, Fen

Re: [PHP-DB] PHP5-MySQL Not Connecting Through Socket

how about change bind-address = 127.0.0.1 to bind-address = your.real.ip.address may be it works. I got the same trouble a few days ago, but I forgot how I fixed it .. :-( some changes in my.cnf On 8/30/05, Evan J <[EMAIL PROTECTED]> wrote: > > Hi, > > I am running PHP 5.0

Re: [PHP-DB] PHP5-MySQL Not Connecting Through Socket

, then check your entry in > > the mysql database in the user table. You should have an entry for localhost > > and check that the PRIVILEGES and password are set correctly. > > > > All I can offer for now. > > > > Later. > > > > Roger > >

Re: [PHP-DB] PHP5-MySQL Not Connecting Through Socket

ly. > > All I can offer for now. > > Later. > > Roger > > ----- Original Message - > From: "Evan J" <[EMAIL PROTECTED]> > To: > Sent: Tuesday, August 30, 2005 2:28 PM > Subject: Re: [PHP-DB] PHP5-MySQL Not Connecting Through Socket &

Re: [PHP-DB] PHP5-MySQL Not Connecting Through Socket

ost? > > roger > - Original Message - > From: "Evan J" <[EMAIL PROTECTED]> > To: > Sent: Tuesday, August 30, 2005 1:01 PM > Subject: Re: [PHP-DB] PHP5-MySQL Not Connecting Through Socket > > > I commented out the bind-address and restarted MySQL. St

Re: [PHP-DB] PHP5-MySQL Not Connecting Through Socket

I commented out the bind-address and restarted MySQL. Still refuses to make connection through Unix socket. And for permissions, they came back as I was expected; I have created my mysql user to have access to "localhost" so: mysql -h127.0.0.1 -D dbname -u -p # Rejected, obviously mysql -h -D dbna

RE: [PHP-DB] PHP5-MySQL Not Connecting Through Socket

Comment out the bind-address this allows mysqld to bind to all IPs; accordingly determine if you only want it local or externally available. Finally attempt to connect to the mysql server using the mysql -h127.0.0.1 -u -p mysql -h -u -p mysql -hlocalhost -u -p you may find the user permissions

[PHP-DB] PHP5-MySQL Not Connecting Through Socket

Hi, I am running PHP 5.0.4 and MySQL 4.1.3a. (+Apache 2.0.54) When I run a PHP script that attempts to connect to MySQL I get the following error: Database ERROR:Can't connect to local MySQL server through socket '/usr/local/mysql/tmp/mysql.sock' (13) I have placed my socket file on such locatio