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
