来自网络,感谢开源,感谢分享
通过rpm安装mysql,测试版本5.1.48
1、在linux下通过:
#useradd multi -g mysql -s /sbin/nologin添加一个multi用户,并加入到mysql组
#passwd multi给multi用户添加密码,这里设置的密码为multi
2、拷贝数据文件:
rpm安装mysql默认datadir为/var/lib/mysql (同时启动两个mysql,拷贝2份数据文件)
#cp -R /var/lib/mysql /var/lib/mysql1
#cp -R /var/lib/mysql /var/lib/mysql2
3、修改权限
#chmod -R 777 /var/lib/mysql1
#chmod -R 777 /var/lib/mysql2
4、设置my.cnf
My.cnf如下:
# This file should probably be in your home dir (~/.my.cnf)
# or /etc/my.cnf
# Version 2.1 by Jani Tolonen
[mysqld_multi]
mysqld= /usr/bin/mysqld_safe
mysqladmin = /usr/bin/mysqladmin
user= multi
password= multi
[mysqld1]
socket= /tmp/mysql.sock1
port= 3306
pid-file= /