Re: I'm prepared to feel like an idiot... But I just simply need the answer :)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Jason Pruim wrote:

On Aug 1, 2007, at 9:55 AM, Michael Preslar wrote:

@mysql_connect('localhost', 'user', 'password') or die("Cannot
connect to DB!" . mysql_error());
..
cannot connect to DB!Can't connect to local MySQL server through
socket '/var/mysql/mysql.sock' (2)qs:/volumes/raider/webserver/
documents/tests/ticklers japruim$

MySQL is running right? (I know, silly question, but have to make sure)

If it is.. grep sock /etc/my.ini .. Bet the socket file its creating
is in /tmp or /var/lib/mysql

Okay, so the command didn't work.. couldn't find my.ini... But I just cd'ed into /tmp and there is a file mysql.sock in there... Do I need to move that somewhere else? I realize that this is starting to get off topic for this list... So Maybe I should take this to a mysql list since it looks like php isn't at fault?

I *think* the mysql config file is named: my.cnf
so run a slocate or find on your system to see where it is and look at the line: socket = /var/run/mysqld/mysqld.sock

You can also go into your php.ini file and check out the line:
mysql.default_socket =
and perhaps setting that to where it is located in your /tmp directory will do the trick...

-B



--

Jason Pruim
Raoset Inc.
Technology Manager
MQC Specialist
3251 132nd ave
Holland, MI, 49424
www.raoset.com
japruim@xxxxxxxxxx

--PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux