Hi Krishna,
thanks for the your answer !!!
I have three different my.cnf for my three instances but one general
my.cnf to manage all 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
but if I put the variable prompt in the specific my.cnf (for example /
etc/mysql.config/my50_SIA_SVILUPPO.cnf),
the prompt doesn't change !!!!
By
Il giorno 22/dic/08, alle ore 11:59, Krishna Chandra Prajapati ha
scritto:
Hi Stefano,
You are running three mysql instance on single server. You can have
three my.cnf say my.cnf, my1.cnf, my2.cnf with different port and
socket and other information in them. In this way you can set the
prompt for different instance.
On Mon, Dec 22, 2008 at 3:46 PM, Stefano Elmopi <stefano.elm...@sociale.it
> wrote:
I need advice.
I have three instances of MySQL on a single server.
How can I change the MySQL prompt depending of the instance on which
connecting ?
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.
Thanks
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=prajapat...@gmail.com
--
Krishna Chandra Prajapati
Mob: 9912924044
Email-id: prajapat...@gmail.com
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
