Hi Krishna,
I use the script mysql_multi to stop and the start several, or all,
instances.
At the end, to work with more ease,
I will create scripts to connect to each instance
and in the script force the variable prompt at the connection
seems easy
Thanks for all !!!
Il
Hi Stefano,
I believe that, different mysql configuration file for different mysql
instance is a better idea. In your case, if any thing goes wrong with my.cnf
Then, it is going to effect all mysql instance (either restart mysql server
or any other way). It has a lots of disadvantages.
You might
Hi Krishna,
the problem is that you use --default-file on the command line and in
this mode it's working fine,
I also tried,
but I have the configuration of the variable "default-file" in the
general my.cnf and I enter in MySQL
in this way:
mysql --socket=/tmp/mysql50_SIA_SVILUPPO.sock
W
Hi Stefano,
I have tested. It's working fine without any issue.
Open mysql configuration(.cnf) file referencing to 1st mysql instance. Add
the below entires and restart the mysql server.
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
pro
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
pas
prajapat...@gmail.com ("Krishna Chandra Prajapati") writes:
> 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.
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/My
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 b
Ciao Stefano,
how do you connect to the different instances?
if you use different operating system users or different mysql home
directories
just put in the home directory of each user a .my.cnf file (or my.cnf in the
mysql home)
with just the prompt setting in the [mysql] section.
NOTE: in the
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
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
11 matches
Mail list logo
