Running php script that connects to mysql db in shell

Question

I prefer running php scripts in the shell as the output comes directly and not in tranches like in a browser. This can be very helpful to see the script is actually still working and also to see which part of a long script takes the longest.

When I call php scripts from the shell like this

php filename.php

it works fine, but only so long as no db connection is established in the script.

Apparently, the mysql_connect() seems to fail:

Warning: mysql_connect(): [2002] No such file or directory (trying to connect via unix:///var/mysql/mysql.sock)

How can I fix this?

Thanks!

Charles

EDIT 1

I connect to the db as follows:

//Connect to db
$user="root";
$databasePassword="";
$host="localhost";
$database="database1";
$identifier=mysql_connect($host,$user,$databasePassword,true);
$db1=mysql_select_db($database);

SOLUTION FOUND

This showed me the right way to do it - it's as simple as replacing "localhost" with "127.0.0.1", because: "The reason is that "localhost" is a special name for the mysql driver making it use the unix socket to connect to mysql instead of the a tcp socket."

Does the mysql unix socket exist at /var/mysql/mysql.sock? — Jon Lin
– Jon Lin, Commented Jul 23, 2012 at 18:49
What OS? You might have to change the path of mysql, check the path — Kush
– Kush, Commented Jul 23, 2012 at 18:49
As stated in the introduction to the PHP manual chapter on the mysql_* functions: This extension is not recommended for writing new code. Instead, either the mysqli or PDO_MySQL extension should be used. See also the MySQL API Overview for further help while choosing a MySQL API. — eggyal
– eggyal, Commented Jul 23, 2012 at 18:53
Kush I run Mac OS X 10.7.4. @JonLin How do I check whether the socket exists there? — Dennis Hackethal
– Dennis Hackethal, Commented Jul 23, 2012 at 18:53

mdo · Accepted Answer · 2012-07-23 18:51:53Z

1

Show your mysql_connect() statement, perhaps you should try to connect to localhost:3306 if your daemon listens on this port.

see: php.net/mysql_connect

If the same script works when called via browser obviously your ini files for the command line environment differ. ini_get("mysql.default_host") shows what setting is used if you do not specify a host to connect to.

answered Jul 23, 2012 at 18:51

mdo

7,1513 gold badges27 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Dennis Hackethal Over a year ago

ini_get("mysql.default_host") does not show anything... localhost:3306 instead of localhost does not work (although it runs on 3306)

Dennis Hackethal Over a year ago

Please see question edit - this is how I connect. In the browser everything works fine.

Collectives™ on Stack Overflow

Running php script that connects to mysql db in shell

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related