一台服务器安装两个mysql数据库的方法
下载mysql-4.1.11.tar.gz包
shell> groupadd mysql
shell> useradd -g mysql mysql
shell> tar -xzvf mysql-4.1.11.tar.gz
shell> cd mysql-4.1.11
shell> ./configure --prefix=/usr/local/mysql
shell> make
shell> make install
shell> cp support-files/my-medium.cnf /etc/my.cnf
shell> /usr/local/mysql/bin/mysql_install_db
shell> /usr/local/mysql/bin/mysqld_safe &
shell> /usr/local/mysql/bin/mysqladmin -u root password 'new-password'
此时停掉mysql,上面只是安装一个数据库，并测试数据库是否安装好
下面才是本文的主题
shell> cd /usr/local/mysql/
shell> mv var varbak
shell> /usr/local/mysql/share/mysql/mysql.server
shell> mv var var3307
shell> mv varbak var
shell> cp /etc/my.cnf /usr/local/mysql/var
shell> cp /etc/my.cnf /usr/local/mysql/var3307
shell> vi /usr/local/mysql/var3307/my.cnf
修改前两个var
Set some defaults
datadir=/usr/local/mysql/var
extra_args=""
if test "$datadir" != "/usr/local/mysql/var"
then
extra_args="-e $datadir/my.cnf"
fi
为
Set some defaults
datadir=/usr/local/mysql/var3307
extra_args=""
if test "$datadir" != "/usr/local/mysql/var3307"
then
extra_args="-e $datadir/my.cnf"
fi
Set some defaults
datadir=/usr/local/mysql/var3307
extra_args=""
if test "$datadir" != "/usr/local/mysql/var3307"
then
extra_args="-e $datadir/my.cnf"
fi
修改下面语句
echo $echo_n "Starting MySQL"
$bindir/mysqld_safe --datadir=$datadir --pid-file=$pid_file >/dev/null 2>&1 &
为
echo $echo_n "Starting MySQL"
$bindir/mysqld_safe --sock=/tmp/mysock3307.sock --port=3307 --datadir=$datadir --pid-file=$pid_file >/dev/null 2>&1 &
shell> cd /etc/init.d
shell> mysql start
shell> mysql3307 start
