CODEWITHSUNDEEP
mysqlmy.cnf
mviswa
mviswa

Reputation: 145

Which variables to set under which in my.cnf file

I am a newbie to mysql , Just want to know which variables should i set under which blocks , I mean what variables should be under

[mysql]

What variables under

[mysqld],[mysqladmin],...

and so on

help is appreciated

Upvotes: 0

Views: 786

Answers (2)

Bjoern
Bjoern

Reputation: 16304

Those blocks are for the different programs within any mysql installation.

For example, the mysqld and mysql groups apply to the mysqld server and the mysql client program, respectively.

You might want to have a look into the manual pages titled "using option files" for more details.

Upvotes: 0

Mahesh Patil
Mahesh Patil

Reputation: 1551

You should set all global variables values under [mysqld] section of my.cnf file and restart server to have effect of changed values on your server.

Upvotes: 2

Related Questions