I'm able to connect to a MySQL database through PHP but not through
the mysql command. When I try I get the following error:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)

Any ideas?

I don't know if it matters but the MySQL server isn't installed
locally - traffic sent to 127.0.0.1:3333 is SSH port forwarded to an
SSH server which has the MySQL server installed on it.

yawnmoth <terra1024 (AT) yahoo (DOT) com> writes:

It matters - when you connect to "localhost", the MySQL client lib
connects to a local domain socket (that's the /tmp/mysql.sock in the
error above) instead of resolving the host name to 127.0.0.1.

To connect through your tunnel, you must specify the IP address in your
connection string, not "localhost."

sherm--

--
Sherm Pendley
<http://camelbones.sourceforge.net>
Cocoa Developer