(mysql.info.gz) Multiple-server clients
Info Catalog
(mysql.info.gz) Multiple Unix servers
(mysql.info.gz) Multiple servers
5.10.3 Using Client Programs in a Multiple-Server Environment
-------------------------------------------------------------
When you want to connect with a client program to a MySQL server that is
listening to different network interfaces than those compiled into your
client, you can use one of the following methods:
* Start the client with `--host=HOST_NAME --port=PORT_NUMBER' to
connect via TCP/IP to a remote server, with `--host=127.0.0.1
--port=port_number' to connect via TCP/IP to a local server, or
with `--host=localhost --socket=FILE_NAME' to connect to a local
server via a Unix socket file or a Windows named pipe.
* As of MySQL 4.1, start the client with `--protocol=tcp' to connect
via TCP/IP, `--protocol=socket' to connect via a Unix socket file,
`--protocol=pipe' to connect via a named pipe, or
`--protocol=memory' to connect via shared memory. For TCP/IP
connections, you may also need to specify `--host' and `--port'
options. For the other types of connections, you may need to
specify a `--socket' option to specify a Unix socket file or named
pipe name, or a `--shared-memory-base-name' option to specify the
shared memory name. Shared memory connections are supported only
on Windows.
* On Unix, set the `MYSQL_UNIX_PORT' and `MYSQL_TCP_PORT'
environment variables to point to the Unix socket file and TCP/IP
port number before you start your clients. If you normally use a
specific socket file or port number, you can place commands to set
these environment variables in your `.login' file so that they
apply each time you log in. Environment variables.
* Specify the default Unix socket file and TCP/IP port number in the
`[client]' group of an option file. For example, you can use
`C:\my.cnf' on Windows, or the `.my.cnf' file in your home
directory on Unix. Option files.
* In a C program, you can specify the socket file or port number
arguments in the `mysql_real_connect()' call. You can also have
the program read option files by calling `mysql_options()'.
C API functions.
* If you are using the Perl `DBD::mysql' module, you can read options
from MySQL option files. For example:
$dsn = "DBI:mysql:test;mysql_read_default_group=client;"
. "mysql_read_default_file=/usr/local/mysql/data/my.cnf";
$dbh = DBI->connect($dsn, $user, $password);
Perl.
Other programming interfaces may provide similar capabilities for
reading option files.
Info Catalog
(mysql.info.gz) Multiple Unix servers
(mysql.info.gz) Multiple servers
automatically generated byinfo2html