Thanks for the all answers !!!
It's ok,
even if I have three different my.cnf for my three instances,
my general my.cnf is:
[mysqld_multi]
mysqld = /opt/local/mysql50/bin/mysqld_safe
mysqladmin = /opt/local/mysql50/bin/mysqladmin
user = root
password = mysys2008srv
log = /MYSQL/MYSQL_LOG/Mysqld_Multi_Log/mysqld_multi.log
## ISTANZE DELLA PARTE PRODUZIONE
##-------------------------------
## ISTANZA SIA DI PRODUZIONE
##--------------------------
[mysqld01]
defaults-file = /etc/mysql.config/my50_SIA.cnf
socket = /tmp/mysql50_SIA.sock
port = 3307
pid-file = /DB_MYSQL_PRODUZIONE/MYSQL50/SIA/mysql50_SIA.pid
datadir = /DB_MYSQL_PRODUZIONE/MYSQL50/SIA
## ISTANZA IPPOFONO DI PRODUZIONE
##-------------------------------
[mysqld02]
defaults-file = /etc/mysql.config/my50_IPPOFONO.cnf
socket = /tmp/mysql50_IPPOFONO.sock
port = 3306
pid-file = /DB_MYSQL_PRODUZIONE/MYSQL50/IPPOFONO/mysql50_IPPOFONO.pid
datadir = /DB_MYSQL_PRODUZIONE/MYSQL50/IPPOFONO
###############################################################################
## ISTANZE DELLA PARTE SVILUPPO
##-----------------------------
## ISTANZA SIA DI SVILUPPO
##------------------------
[mysqld11]
defaults-file = /etc/mysql.config/my50_SIA_SVILUPPO.cnf
socket = /tmp/mysql50_SIA_SVILUPPO.sock
port = 3317
pid-file = /DB_MYSQL_SVILUPPO/MYSQL50/SIA_SVILUPPO/
mysql50_SIA_SVILUPPO.pid
datadir = /DB_MYSQL_SVILUPPO/MYSQL50/SIA_SVILUPPO
to have three different prompts,
I have to create three scripts connection where I configure the prompt
variable.
I say right?
By
Il giorno 22/dic/08, alle ore 12:07, Warren Young ha scritto:
Stefano Elmopi wrote:
If I put the variable prompt in the general my.cnf, the prompt is
changed but for all instances.
If I put in the variable prompt in the my.cnf associated with the
instance
in the [mysql] section, the prompt does not change.
This is because the client reads from my.cnf before it starts
talking to the server, and it can read any my.cnf file it likes.
There's no way you can mandate that a single my.cnf file gets used
for both the server and any client session connecting to it.
Instead of running mysql(1) directly, I'd run it via one of three
scripts, each of which sets up its environment so as to force
mysql(1) to read a different my.cnf file in each case. This will
also let you hard-code other information about each particular
server that isn't important to keep secret, like the login name and
the DB name.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=stefano.elm...@sociale.it
Ing. Stefano Elmopi
Gruppo Darco - Area ICT Sistemi
Via Ostiense 131/L Corpo B, 00154 Roma
cell. 3466147165
tel. 0657060500
email:stefano.elm...@sociale.it
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
