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:[EMAIL PROTECTED] > > Sent: Saturday, April 15, 2006 12:53 AM > > To: mysql@lists.mysql.com > > 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 ======================================== -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]