Linux 安装两个MySQL服务器的操作步骤

MYSQL版本：MYSQL-5.6

安装步骤：

1. 第一个MYSQL安装路径/usr/local/mysql 监听3306端口
   启动文件/etc/init.d/mysql
2. 第二个MYSQL安装路径/data/mysql 监听3307端口
   启动文件/etc/init.d/mysql2

安装第一个

Setup 1:#wget http://www.cmake.org/files/v2.8/cmake-2.8.12.2.tar.gz#tar -zxvf cmake-2.8.12.2.tar.gz#cd cmake-2.8.12.2#./bootstrap#./configure#make && make install  系统如果是CENTOS，刚要安装另一个组件#wget http://invisible-island.net/datafiles/release/ncurses.tar.gz#./configure#make && make install Setup 2:安装MYSQL 5.5.37#wget http://cdn.mysql.com/Downloads/MySQL-5.5/mysql-5.5.37.tar.gztar -zxvf mysql-5.5.37.tar.gz#cd mysql-5.5.37#cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DEXTRA_CHARSETS=all -DENABLED_LOCAL_INFILE=1 -DWITH_READLINE=1 -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_EMBEDDED_SERVER=1 -DWITH_SSL=system  #make && make install  慢长的等待过后终于完成了  #groupadd mysql#useradd -g mysql mysql#cp /usr/local/mysql/support-files/my-medium.cnf /etc/my.cnf  #vim /etc/my.cnf #需要加入basedir,和datadir否则会出问题[mysqld]basedir =/usr/local/mysqldatadir =/usr/local/mysql/data    #/usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data &  #chown -R mysql /usr/local/mysql/data#chgrp -R mysql /usr/local/mysql/.#cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql#chmod 755 /etc/init.d/mysql#chkconfig --level 345 mysql on#echo “/usr/local/mysql/lib/mysql” >> /etc/ld.so.conf#echo “/usr/local/lib” >>/etc/ld.so.conf#ldconfig  #/etc/init.d/mysql start  #/usr/local/mysql/bin/mysqladmin -u root password broadengate  Empire CMS,phome.net  #/etc/init.d/mysql restart#/etc/init.d/mysql stopOK终于完成~

安装第2个

#tar -zxvf mysql-5.5.37.tar.gz#cd mysql-5.5.37#cmake -DCMAKE_INSTALL_PREFIX=/data/mysql -DMYSQL_DATADIR=/data/mysql/data -DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_FEDERATED_STORAGE_ENGINE=1 -DWITH_PARTITION_STORAGE_ENGINE=1 -DWITH_PERFSCHEMA_STORAGE_ENGINE=1 -DMYSQL_UNIX_ADDR=/data/mysql/mysqld.sock -DMYSQL_TCP_PORT=3307 -DWITH_DEBUG=0 -DENABLED_LOCAL_INFILE=1 -DWITH_READLINE=1 -DWITH_SSL=system -DWITH_ZLIB=system -DWITH_EMBEDDED_SERVER=1#make && make install#cp /data/mysql/support-files/my-medium.cnf /data/mysql/my.cnf   #vim /data/mysql/my.cnf #需要加入basedir,和datadir否则会出问题[mysqld]basedir =/data/mysqldatadir =/data/mysql/data      #/data/mysql/scripts/mysql_install_db --user=mysql --basedir=/data/mysql --datadir=/data/mysql/data &   #chown -R mysql /data/mysql/data#chgrp -R mysql /data/mysql/.#cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql2#chmod 755 /etc/init.d/mysql2

好了，下面才是重点

#vi /etc/init.d/mysql2  1）找到以下文件进行添加basedir=/data/mysqldatadir=/data/mysql/data  conf=/data/mysql/my.cnf  2）修改以下参数  把$bindir/mysqld_safe --datadir=$datadir --pid-file=$server_pid_file $other_args >/dev/null 2>&1&替换为：  $bindir/mysqld_safe --defaults-file=/data/mysql/my.cnf --datadir=$datadir --pid-file=$server_pid_file $other_args >/dev/null 2>&1 &  3）把下面这句注释掉(前面加个#)：  parse_server_arguments `$print_defaults $extra_args mysqld server mysql_server mysql.server`       4).保存退出并添加服务：  chkconfig --add /etc/init.d/mysql2




分别启动2个

# /etc/init.d/mysql start  # /etc/init.d/mysql2 start

所不同的是，我们在第二个MYSQL登陆时要加上sock可以进入，否则默认是第一个数据库

1

mysql -uroot -p --socket=/data/mysql/mysql.sock