Databases Reference
In-Depth Information
password=
the_password
database=music
If you're concerned about security, you can omit specifying a password and simply
write the option
password
:
[mysql]
host=sadri.learningmysql.com
port=57777
user=allmusic
password
database=music
This way, the monitor knows that you want to use a password, and it'll prompt you
for the password before trying to connect to the server.
Structure of the Options File
We saw in the last section how you can specify options for the MySQL monitor. An
options file can have a section for each program that uses it. For example, you can have
a
[mysql]
section for the
mysql
program and a
[mysqldump]
section for the
mysqldump
program. Similarly, you can have a
[mysqld]
section for the MySQL server daemons
mysqld
,
mysqld_safe
, and
mysqld-nt
.
Where options are common to all client programs, they can be consolidated under a
[client]
section. Similarly, options common to all server programs can be listed under
a
[server]
section.
Be careful not to make program options too generic. For example, the
mysql
program
is a client and takes a
database
option. However,
mysqladmin
and
mysqlshow
are exam-
ples of client programs that don't understand this option. If you include the database
option in the
[client]
section, like this:
[client]
database=music
these programs will just complain and quit, as below:
$
mysqladmin status
mysqladmin: unknown variable 'database=music'
You should include the
database
option in a separate group for the
[mysql]
program,
rather than including it in the
[client]
group.
Let's look at a more interesting options file:
[server]
user=mysql
port=57777
basedir=/usr/local/mysql-standard-5.0.22-linux-i686
socket=/home/mysql/server1.sock