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: [email protected]
> > 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]
