Oracle 5.0, Reference Manual

Page: 577 / 3232

Using Client Programs in a Multiple-Server Environment
557
• 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.21, “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. 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()
call. You can also have the program read option files by calling
mysql_options()
. See Section 20.6.6, “C API Function Descriptions” .
• 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);
See Section 20.8, “MySQL Perl API” .
Other programming interfaces may provide similar capabilities for reading option files.