创建mysql2用户
[root@localhost ~]# useradd mysql2
[root@localhost ~]# su - mysql2
[mysql2@localhost ~]$ ls
安装MySQL需要用到cmake,下载
[mysql2@localhost ~]$ wget http://www.cmake.org/files/v2.8/cmake-2.8.10.1.tar.gz
--2014-11-17 10:13:00-- http://www.cmake.org/files/v2.8/cmake-2.8.10.1.tar.gz
正在解析主机 www.cmake.org... 66.194.253.19
正在连接 www.cmake.org|66.194.253.19|:80... 已连接。
已发出 HTTP 请求,正在等待回应... 200 OK
长度:5767574 (5.5M) [application/x-gzip]
正在保存至: “cmake-2.8.10.1.tar.gz”
[=======================================================================================> ] 5,625,101 89.4K/s eta(英国中部时98% [========================================================================================> ] 5,658,681 92.0K/s eta(英国中部时98% [========================================================================================> ] 5,689,341 93.7K/s eta(英国中部时99% [=========================================================================================> ] 5,723,245 93.6K/s eta(英国中部时99% [=========================================================================================> ] 5,759,421 96.4K/s eta(英国中部时100%[==========================================================================================>] 5,767,574 96.7K/s in 84s
2014-11-17 10:14:30 (67.2 KB/s) - 已保存 “cmake-2.8.10.1.tar.gz” [5767574/5767574])
复制下载的MySQL软件,并修改权限
[root@localhost mysql]# cp mysql-5.6.21.tar.gz /home/mysql2/
[root@localhost mysql2]# chown -R mysql2.mysql2 mysql-5.6.21.tar.gz
安装cmake
[mysql2@localhost ~]$ tar xvfz cmake-2.8.10.1.tar.gz
cmake-2.8.10.1/.gitattributes
cmake-2.8.10.1/.hooks-config.bash
cmake-2.8.10.1/bootstrap
cmake-2.8.10.1/ChangeLog.manual
[root@localhost mysql2]# cd cmake-2.8.10.1
[root@localhost cmake-2.8.10.1]# ls -l
总用量 2980
-rwxr-xr-x 1 mysql2 mysql2 54084 11月 7 2012 bootstrap
-rw-r--r-- 1 mysql2 mysql2 190107 11月 7 2012 ChangeLog.manual
-rw-r--r-- 1 mysql2 mysql2 2603523 11月 7 2012 ChangeLog.txt
-rw-r--r-- 1 mysql2 mysql2 5395 11月 7 2012 CMakeCPack.cmake
-rw-r--r-- 1 mysql2 mysql2 2536 11月 7 2012 CMakeCPackOptions.cmake.in
-rw-r--r-- 1 mysql2 mysql2 153 11月 7 2012 CMakeGraphVizOptions.cmake
-rw-r--r-- 1 mysql2 mysql2 24542 11月 7 2012 CMakeLists.txt
-rw-r--r-- 1 mysql2 mysql2 4481 11月 7 2012 CMakeLogo.gif
-rw-r--r-- 1 mysql2 mysql2 796 11月 7 2012 cmake_uninstall.cmake.in
-rw-r--r-- 1 mysql2 mysql2 2204 11月 7 2012 CompileFlags.cmake
-rwxr-xr-x 1 mysql2 mysql2 99 11月 7 2012 configure
-rw-r--r-- 1 mysql2 mysql2 2637 11月 7 2012 Copyright.txt
-rw-r--r-- 1 mysql2 mysql2 1050 11月 7 2012 CTestConfig.cmake
-rw-r--r-- 1 mysql2 mysql2 3258 11月 7 2012 CTestCustom.cmake.in
-rw-r--r-- 1 mysql2 mysql2 145 11月 7 2012 CTestCustom.ctest.in
-rw-r--r-- 1 mysql2 mysql2 809 11月 7 2012 DartConfig.cmake
-rw-r--r-- 1 mysql2 mysql2 4144 11月 7 2012 DartLocal.conf.in
drwxrwxr-x 3 mysql2 mysql2 4096 11月 17 10:17 Docs
-rw-r--r-- 1 mysql2 mysql2 28046 11月 7 2012 doxygen.config
drwxrwxr-x 4 mysql2 mysql2 4096 11月 17 10:17 Example
drwxrwxr-x 9 mysql2 mysql2 20480 11月 17 10:17 Modules
-rw-r--r-- 1 mysql2 mysql2 1946 11月 7 2012 Readme.txt
drwxrwxr-x 7 mysql2 mysql2 32768 11月 17 10:17 Source
drwxrwxr-x 2 mysql2 mysql2 4096 11月 17 10:17 Templates
drwxrwxr-x 150 mysql2 mysql2 4096 11月 17 10:17 Tests
drwxrwxr-x 15 mysql2 mysql2 4096 11月 17 10:17 Utilities
[root@localhost cmake-2.8.10.1]# ./configure && make && make install
---------------------------------------------
CMake 2.8.10.1, Copyright 2000-2012 Kitware, Inc.
Found GNU toolchain
C compiler on this system is: gcc
C++ compiler on this system is: g++
Makefile processor on this system is: gmake
g++ is GNU compiler
g++ has setenv
g++ has unsetenv
g++ does not have environ in stdlib.h
g++ has STL in std:: namespace
g++ has ANSI streams
g++ has streams in std:: namespace
安装MySQL
[mysql2@localhost ~]# mkdir /mysql2
[mysql2@localhost ~]# cd /mysql2
[mysql2@localhost ~]# chown -R mysql2.mysql2 /mysql2
[mysql2@localhost ~]$ cd /mysql2/
[mysql2@localhost mysql2]$ mkdir etc init.d data log tmp binlog
[mysql2@localhost ~]$ tar xvfz mysql-5.6.21.tar.gz
mysql-5.6.21/
mysql-5.6.21/BUILD/
mysql-5.6.21/BUILD/build_mccge.sh
mysql-5.6.21/BUILD/compile-pentium-gcov
mysql-5.6.21/BUILD/compile-pentium
mysql-5.6.21/BUILD/compile-pentium-debug-max-no-ndb
[mysql2@localhost mysql-5.6.21]$ cmake -DCMAKE_INSTALL_PREFIX=/mysql2 \
> -DSYSCONFDIR=/mysql2/etc \
> -Dmysql_DATADIR=/mysql2/data \
> -Dmysql_TCP_PORT=3307 \
> -DWITH_PARTITION_STORAGE_ENGINE\
> -DWITH_ARCHIVE_STORAGE_ENGINE=1\
> -DWITHOUT_FEDERATED_STORAGE_ENGINE=1\
> -Dmysql_UNIX_ADDR=/mysql2/tmp/mysql2d.sock \
> -Dmysql_USER=mysql2 \
> -DEXTRA_CHARSETS=all \
> -DWITH_READLINE=1 \
> -DWITH_SSL=system \
> -DWITH_EMBEDDED_SERVER=1 \
> -DENABLED_LOCAL_INFILE=1 \
> -DWITH_INNOBASE_STORAGE_ENGINE=1
-- Running cmake version 2.8.10.1
-- The C compiler identification is GNU 4.4.7
-- The CXX compiler identification is GNU 4.4.7
-- Check for working C compiler: /usr/bin/cc
-- Check for working C compiler: /usr/bin/cc -- works
-- Detecting C compiler ABI info
-- Detecting C compiler ABI info - done
-- Check for working CXX compiler: /usr/bin/c++
-- Check for working CXX compiler: /usr/bin/c++ -- works
-- Detecting CXX compiler ABI info
-- Detecting CXX compiler ABI info - done
[mysql2@localhost mysql-5.6.21]$make && make install
Scanning dependencies of target INFO_BIN
[ 0%] Built target INFO_BIN
Scanning dependencies of target INFO_SRC
[ 0%] Built target INFO_SRC
Scanning dependencies of target abi_check
[ 0%] Built target abi_check
Scanning dependencies of target zlib
[ 0%] Building C object zlib/CMakeFiles/zlib.dir/adler32.c.o
[ 0%] Building C object zlib/CMakeFiles/zlib.dir/compress.c.o
[ 0%] Building C object zlib/CMakeFiles/zlib.dir/crc32.c.o
[ 0%] Building C object zlib/CMakeFiles/zlib.dir/deflate.c.o
[ 0%] Building C object zlib/CMakeFiles/zlib.dir/gzio.c.o
[ 0%] Building C object zlib/CMakeFiles/zlib.dir/infback.c.o
[ 0%] Building C object zlib/CMakeFiles/zlib.dir/inffast.c.o
[ 0%] Building C object zlib/CMakeFiles/zlib.dir/inflate.c.o
[mysql2@localhost mysql-5.6.21]$ cd support-files/
[mysql2@localhost support-files]$ cp my-default.cnf /mysql2/etc/my.cnf
[mysql2@localhost support-files]$ cp mysql.server /mysql2/init.d/mysql
[mysql2@localhost ~]$ cd /mysql2/
[mysql2@localhost mysql2]$ ls
bin data etc init.d lib man README share support-files
COPYING docs include INSTALL-BINARY log mysql-test scripts sql-bench
[mysql2@localhost mysql2]$ chmod 755 scripts/mysql_install_db
[mysql2@localhost mysql2]$ chmod +x init.d/mysql
初始化MySQL系统表
[mysql2@localhost mysql2]$ ./scripts/mysql_install_db --user=mysql2 --basedir=/mysql2 --datadir=/mysql2/data
Installing MySQL system tables...2014-11-17 11:04:07 0 [Warning] Ignoring user change to 'mysql2' because the user was set to 'mysql' earlier on the command line
2014-11-17 11:04:07 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2014-11-17 11:04:07 5185 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-11-17 11:04:07 5185 [Note] InnoDB: The InnoDB memory heap is disabled
2014-11-17 11:04:07 5185 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2014-11-17 11:04:07 5185 [Note] InnoDB: Memory barrier is not used
2014-11-17 11:04:07 5185 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-11-17 11:04:07 5185 [Note] InnoDB: Using Linux native AIO
2014-11-17 11:04:07 5185 [Note] InnoDB: Using CPU crc32 instructions
2014-11-17 11:04:07 5185 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2014-11-17 11:04:07 5185 [Note] InnoDB: Completed initialization of buffer pool
2014-11-17 11:04:08 5185 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
2014-11-17 11:04:08 5185 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
2014-11-17 11:04:08 5185 [Note] InnoDB: Database physically writes the file full: wait...
2014-11-17 11:04:08 5185 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
2014-11-17 11:04:08 5185 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
编辑/mysql2/ect/my.cnf文件[mysqld]下,添加如下内容:
[mysqld]
pid-file = /mysql2/data/mysql2.pid
log-error = /mysql2/log/error.log
general_log = ON
general_log_file = /mysql2/log/mysql2.log
tmpdir = /tmp
basedir = /mysql2
datadir = /mysql2/data
autocommit=0
port=3307
[mysqld_safe]
socket = /mysql2/tmp/mysql2.sock
启动MySQL:
[mysql2@localhost mysql2]$ ./init.d/mysql start
Starting MySQL SUCCESS!
查看进程
[mysql2@localhost mysql2]$ ps -ef | grep mysql2
root 20349 8196 0 15:01 pts/2 00:00:00 su - mysql2
mysql2 20350 20349 0 15:01 pts/2 00:00:00 -bash
root 22509 8250 0 17:54 pts/3 00:00:00 su - mysql2
mysql2 22510 22509 0 17:54 pts/3 00:00:00 -bash
mysql2 24443 1 0 18:12 pts/3 00:00:00 /bin/sh /mysql2/bin/mysqld_safe --datadir=/mysql2/data --pid-file=/mysql2/data/mysql2.pid
mysql2 24812 24443 7 18:12 pts/3 00:00:00 /mysql2/bin/mysqld --basedir=/mysql2 --datadir=/mysql2/data --plugin-dir=/mysql2/lib/plugin --log-error=/mysql2/log/error.log --pid-file=/mysql2/data/mysql2.pid --socket=/mysql2/tmp/mysql2.sock --port=3307
mysql2 24836 22510 0 18:12 pts/3 00:00:00 ps -ef
mysql2 24837 22510 0 18:12 pts/3 00:00:00 grep mysql2
[mysql2@localhost mysql2]$
查看端口监听:
[mysql2@localhost mysql2]$ netstat -antp | grep 3307
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
tcp 0 0 :::3307 :::* LISTEN 24812/mysqld
[mysql2@localhost mysql2]$
登陆MySQL,因为这是一台机器安装的第二个MySQL所以需要指定host和socket。
[mysql2@localhost mysql2]$ ./bin/mysql -u root -p -h localhost --socket=/mysql2/tmp/mysql2.sock
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.21-log Source distribution
Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| test |
+--------------------+
4 rows in set (0.00 sec)
mysql> exit
Bye
[mysql2@localhost mysql2]$