一 前期准备
1 cmake包,要求2.8以上版本
2 boost库包
boost Boost库是一个可移植、提供源代码的C++库,作为标准库的后备,是C++标准化进程的开发引擎之一
3 mysql包
二 mysql安装
1 安装依赖包
yum -y install ncurses-devel gcc-\* bzip2-\* bison
2 cmake install
tar xf cmake-3.6.0-rc1.tar
cd cmake-3.6.0-rc1
./configure
make
make install
3 boost
tar xf boost_1_59_0.tar.bz2
mv boost_1_59_0/usr/local/boost
4 mysql
useradd -s /sbin/nologin -r mysql
mkdir-pv /usr/local/mysql/data
tar xf mysql...tar.xx
cmake .-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \-DMYSQL_DATADIR=/usr/local/mysql/data/\-DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock \-DWITH_INNOBASE_STORAGE_ENGINE=1\-DWITH_MYISAM_STORAGE_ENGINE=1\-DENABLED_LOCAL_INFILE=1\-DEXTRA_CHARSETS=all -DDEFAULT\_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general\_ci \-DMYSQL_USER=mysql \-DWITH_DEBUG=0 \-DWITH_EMBEDDED_SERVER=1\-DDOWNLOAD_BOOST=1 -DENABLE_DOWNLOADS=1 -DWITH_BOOST=/usr/local/boost
make
make install
##解释
cmake . \-DCMAKE_INSTALL_PREFIX=/usr/local/mysql 指定安装路径-DMYSQL_DATADIR=/usr/local/mysql/data/指定数据目录-DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock 指定sock文件路径-DWITH_INNOBASE_STORAGE_ENGINE=1安装Innodb存储引擎-DWITH_MYISAM_STORAGE_ENGINE=1安装myisam存储引擎-DENABLED_LOCAL_INFILE=1允许使用Load data命令从本地导入数据-DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci 安装所有字符集、默认字符集utf-8、校验字符-DMYSQL_USER=mysql mysql用户名-DWITH_DEBUG=0 关闭debug-DWITH_EMBEDDED_SERVER=1生成一个libmysqld.a(.so)的库,这个库同时集成了mysql服务与客户端API-DDOWNLOAD_BOOST=1 -DENABLE_DOWNLOADS=1 -DWITH_BOOST=/usr/local/boost 允许boost 允许下载boost库文件
5 安装后操作
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
chmod755 /etc/init.d/mysql
chown mysql.mysql/usr/local/mysql/ -R
ln-sf /usr/local/mysql/bin/* /usr/bin/ln-sf /usr/local/mysql/lib/* /usr/lib/ln-sf /usr/local/mysql/libexec/* /usr/local/libexec
ln-sf /usr/local/mysql/share/man/man1/* /usr/share/man/man1
ln-sf /usr/local/mysql/share/man/man8/* /usr/share/man/man8
修改配置文件 确保路径正确
[root@web01~]#egrep -v "^#|^$" /etc/my.cnf
[mysqld]
datadir=/usr/local/mysql/data
socket=/usr/local/mysql/mysql.sock
symbolic-links=0
[mysqld_safe]
log-error=/var/log/mysql.log
pid-file=/var/run/mysql.pid
!includedir/etc/my.cnf.d
6 初始化数据库
/usr/local/mysql/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/
7 启动mysql
[root@web01 ~]#/etc/init.d/mysql start
8 密码修改
[root@web01 ~]#mysql_secure_installation