温玉的WIKI博客

MySQL编译安装

MySQL编译安装

创建MySQL用户

groupadd -g 27 mysql
useradd -u 27 -g mysql -s /sbin/nologin -M mysql

安装/确认基础软件

yum install -y make cmake gcc gcc-c++ ncurses-devel bison >/dev/null 2>&1

判断CMakeCache.txt文件是否存在

如果存在说明曾经cmake过，需要删除

指定编译参数

cmake -LH 产生CMakeCache.txt, make就按这个cache文件来编译

cmake \
-DCMAKE_INSTALL_PREFIX:PATH=/usr/local/mysql \
-DMYSQL_DATADIR:PATH=/database \
-DSYSCONFDIR:PATH=/usr/local/mysql/etc \
-DWITH_DEBUG:BOOL=on

编译并安装

make && make install

创建配置文件目录

mkdir /usr/local/mysql/etc

生成配置文件

cat /usr/local/mysql/etc/my.cnf
[mysqld]
basedir=/usr/local/mysql
datadir=/database
socket=/var/run/mysqld/mysql.sock
pid-file=/var/run/mysqld/mysql.pid
port=3306
user=mysql
 
[mysqld_safe]
log-error=/var/log/mysqld/mysql5.6-error.log

给予相关目录权限

mkdir /database /var/run/mysqld /var/log/mysqld
chown -R mysql.mysql /usr/local/mysql /database /var/run/mysqld /var/log/mysqld

执行安装的脚本

/usr/local/mysql/scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/database --user=mysql

复制启动文件

cp /usr/local/mysql/support-files/mysql.server /etc/rc.d/init.d/mysql

配置开机启动和启动服务

chkconfig --add mysql5.6
service mysql5.6 start

登录MySQL

mysql -S /var/run/mysql.sock
搜索