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.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
