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.
Содержание 5.0
Страница 1: ...MySQL 5 0 Reference Manual ...
Страница 18: ...xviii ...
Страница 60: ...40 ...
Страница 396: ...376 ...
Страница 578: ...558 ...
Страница 636: ...616 ...
Страница 844: ...824 ...
Страница 1234: ...1214 ...
Страница 1426: ...MySQL Proxy Scripting 1406 The following diagram shows an overview of the classes exposed by MySQL Proxy ...
Страница 1427: ...MySQL Proxy Scripting 1407 ...
Страница 1734: ...1714 ...
Страница 1752: ...1732 ...
Страница 1783: ...Configuring Connector ODBC 1763 ...
Страница 1793: ...Connector ODBC Examples 1773 ...
Страница 1839: ...Connector Net Installation 1819 2 You must choose the type of installation to perform ...
Страница 1842: ...Connector Net Installation 1822 5 Once the installation has been completed click Finish to exit the installer ...
Страница 1864: ...Connector Net Visual Studio Integration 1844 Figure 20 24 Debug Stepping Figure 20 25 Function Stepping 1 of 2 ...
Страница 2850: ...2830 ...
Страница 2854: ...2834 ...
Страница 2928: ...2908 ...
Страница 3000: ...2980 ...
Страница 3122: ...3102 ...
Страница 3126: ...3106 ...
Страница 3174: ...3154 ...
Страница 3232: ...3212 ...