Re: php cli and mysql

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

 



ok.  so the location of mysql.sock is a problem.
I found it at /tmp/mysql.sock

Why is the CLI looking for it at /var/myslq/mysql.sock?

Now the question is...
Do I change the mysql settings so that mysql.sock is at /tmp/ mysql.sock? (If I do, will the PHP module with Apache still be ok?)
or
Do I change where the CLI is looking for mysql.sock?

-James

On Nov 14, 2006, at 1:17 PM, cajbecu wrote:

touch /var/mysql/mysql.sock
chmod 777 /var/mysql/mysql.sock

On 11/14/06, James Tu <jtu@xxxxxxxxxxxxx> wrote:
I'm running a php script from the command line (I'm on OS X) and I'm
getting ...

Warning: mysql_connect(): Can't connect to local MySQL server through
socket '/var/mysql/mysql.sock' (2)

Here's the script (this just tests a connection and a query...the
actual script imports data from text files):


#!/usr/bin/php
<?php

echo "HELLO WORLD\n";
$connection = mysql_connect(HOST, ID, PW);
mysql_select_db(DB, $connection);
$result = mysql_query("SELECT COUNT(*) as num_of_countries from
geo_entities");
$row = mysql_fetch_array($result);
print_r($row);

?>


I tested the script from a browser and the connection and query worked.
Do I have to do something special in order for PHP CLI to connect to
MySQL?

-James

--
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



--
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