Databases Reference
In-Depth Information
You can get a similar effect using the
my_print_defaults
program and specifying the
command groups you're interested in. For example, to see the settings for all clients
and for the
mysqldump
program, you can type:
$
my_print_defaults client mysqldump
--socket=/home/mysql/server1.sock
--all-databases
--result_file=/tmp/dump.sql
--host=localhost
--port=3306
--database=Music
--result_file=/home/saied/dump.sql
Exercises
1. What issues would you consider before storing your password in an options file?
2. On a Linux or Mac OS X system, under what circumstances would the
[server]
section of the
~/.my.cnf
options file be read?
3. How can you tell what options a program uses by default?