79636

Using Client Programs in a MultipleServer Environment

To connect with a Client program to a MySQL server that is listening to different network interfaces from

those compiled into your Client, you can use one of the following methods:

•    Start the Client with -ho3t=host_na/ne [221] --por t=port_number [221] to connect using TCP/

IP to a remote server, with —host=127.0.0.1 [221]—port-port_numbor [221] to connect using TCP/IP to a local server. or with —host*localhost [221]—socket2[221 ] to connect to a local server using a Unix socket file or a Windows named pipę.

•    Start the Client with —protocol-TCP [221] to connect using TCP/IP,--protocol=SOCKET [221] to connect using a Unix socket file. -protocol-PlPE [221] to connect using a named pipę. or

—protocol-MEMORY [221] to connect using shared memory. For TCP/IP connections. you may also need to specify - -host [221] and - -port [221 ] options. For the other types of connections. you may need to specify a -socket [221] option to specify a Unix socket file or Windows namedpipe

name. or a --shared-memory-base-name [221] 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. See Section 2.12, “Environment Variables".

•    Specify the default Unix socket file and TCP/IP port number in the [client] group of an option file. For exam ple. you can use C: my.cnf on Windows, or the .my. cnf file in your home directory on Unix. See Section 4.2.3.3, “Using Option Files'.

•    In a C program, you can specify the socket file or port number arguments in the mysql_real_connect () cali. You can also have the program read option files by calling mysql_optionsU . See Section 22.8.7, “C API Function Descriptions".

•    If you are using the Perl DBD: :mysql module, you can read options from MySQL option files. For example:

Sdsn - "DBI:mysql:t*st;»ysql_r«ad_default_grou|>»cli*nt;"

. "my3ql_read_default_file“/usr/local/Bysql/data/Biy.cnf";

$dbh = DBI->conn«ct(Sdsn, Suser, Spasaword);

See Section 22.10. “MySOL Perl API".

Other programming interfaces may provide similar capabilities for reading option files.