List:General Discussion« Previous MessageNext Message »
From:Mohammed Abdul Azeem Date:April 17 2006 1:38pm
Subject:RE: ~ How to install 3 instances of mysql~
View as plain text  
Thanks Rich.

On Mon, 2006-04-17 at 08:28 -0500, Duzenbury, Rich wrote:
> I just did this last week on a 5.0.18 machine.  It's supported by the
> mysqlmanager out of the box.  Here are a copy of my notes, and worked
> well on a Suse machine.  The locations of your files may not be the
> same.
> 
> # stop the server, if running
> /etc/init.d/mysql stop
> 
> # edit /etc/my.cnf to set up the instances and 
> # and also tell the startup script to use mysqlmanager
> 
> [mysql.server]
> use-manager
> 
> [mysqld07]
> port            = 3307
> socket          = /srv/mysql/lx07sock
> pid-file        = /srv/mysql/lx07/lx09.pid07
> datadir         = /srv/mysql/lx07/data
> log-error       = /srv/mysql/lx07/mysql.error.log
> 
> [mysqld20]
> port            = 3320
> socket          = /srv/mysql/lx20sock
> pid-file        = /srv/mysql/lx20/lx09.pid20
> datadir         = /srv/mysql/lx20/data
> log-error       = /srv/mysql/lx20/mysql.error.log
> 
> # run commands as user mysql
> su mysql
> 
> # go to the main mysql directory
> cd /srv/mysql
> 
> # make a directory for each instance
> mkdir lx07
> mkdir lx20
> 
> mysql_install_db  --datadir=/srv/mysql/lx07/data --user=mysql --verbose
> mysql_install_db  --datadir=/srv/mysql/lx20/data --user=mysql --verbose
> 
> # start the server
> /etc/init.d/mysql start
> 
> # connect to first instance and configure so root can log in
> # from anywhere.  You may or may not want to do this.
> mysql --socket=/srv/mysql/lx07sock
> create user 'root'@'%' identified by 'password'
> grant all on *.* to 'root'@'%' identified by 'password;
> use mysql;
> update user set password=password('password') where user='root';
> flush privileges
> 
> # same for second instance
> mysql --socket=/srv/mysql/lx20sock
> create user 'root'@'%' identified by 'password'
> grant all on *.* to 'root'@'%' identified by 'password';
> use mysql;
> update user set password=password('password') where user='root';
> flush privileges
> 
> Regards,
> Rich
> 
> 
> > -----Original Message-----
> > From: Mohammed Abdul Azeem [mailto:abdul@stripped] 
> > Sent: Saturday, April 15, 2006 12:53 AM
> > To: mysql@stripped
> > Subject: ~ How to install 3 instances of mysql~
> > 
> > Hi,
> > 
> > I need to install 3 instances of mysqld server on a single 
> > machine. Can anyone let me know how this can be acheived ?
> > 
> > It would be helpful if someone can send me some links and 
> > suggestions regarding the same. Also pls lemme know what kind 
> > of a configuration file i need to have in order to acheive the same.
> > 
> > Thanks in advance,
> > Abdul.
> ________________________________________
> This email has been Scanned for Viruses!
>           www.newbreak.com
> 

________________________________________
This email has been Scanned for Viruses!
          www.newbreak.com

========================================
Thread
~ How to install 3 instances of mysql~Mohammed Abdul Azeem15 Apr
  • Re: ~ How to install 3 instances of mysql~mysql15 Apr
    • Re: ~ How to install 3 instances of mysql~Mohammed Abdul Azeem15 Apr
      • Re: ~ How to install 3 instances of mysql~mysql15 Apr
        • RE: ~ How to install 3 instances of mysql~SST - Adelaide)15 Apr
          • RE: ~ How to install 3 instances of mysql~Mohammed Abdul Azeem17 Apr
            • RE: ~ How to install 3 instances of mysql~SST - Adelaide)17 Apr
        • copying table fo other databaseafan15 Apr
          • Re: copying table fo other databaseJorrit Kronjee15 Apr
  • Re: ~ How to install 3 instances of mysql~Santino15 Apr
RE: ~ How to install 3 instances of mysql~Rich Duzenbury17 Apr
  • RE: ~ How to install 3 instances of mysql~Mohammed Abdul Azeem17 Apr