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

Re: [cobalt-users] MYSQL Variables



Hi,

> With MySQL there is No way to access the DB's with TCP Socket
> connection.

You _can_ access databases without a TCP socket connection.

> You need a port open somewhere so that even localhost can OPEN
> a socket to the MySQL DB's. PHP and even mysql -u (username) -p database
> cause's a Socket connection using TCP Socket.

Not quite. When run on localhost and connecting to localhost, a Unix socket
can (and will) be used instead of a TCP/IP port.

Take for example PHP. It will use the "mysql.sock" file (which is a Unix
socket) to connect to MySQL on localhost. It will use a TCP/IP connection,
when connecting to a remote MySQL database.

--
Jens Kristian Søgaard, Mermaid Consulting I/S,
jens@xxxxxxxxxxxxxxxxxxxx,
http://www.mermaidconsulting.com/