mysql 源码编译5.7.28
- mysql源码中带boost与不带boost编译相同
- 创建 mysql 用户
groupadd -r -g 27 mysql
useradd -s /sbin/nologin -r -u 27 -g 27 -d /data/mysql mysql
- 创建mysql文件的家目录用来存放mysql数据库
mkdir /data/mysql
chown mysql.mysql /data/mysql
#注意数据库存放目录必须为空
- 安装相关依赖
yum -y install wget gcc gcc-c++ cmake openssl-devel ncurses-devel zlib-devel bzip2
- 下载boost_1_59_0
wget http://www.sourceforge.net/projects/boost/files/boost/1.59.0/boost_1_59_0.tar.bz2 -c /usr/local/src
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.28.tar.gz -c /usr/local/src
- 解压boost mysql
cd /usr/local/src
tar -xvf boost_1_59_0.tar.bz2 && mv boost_1_59_0 boost
tar -xvf mysql-5.7.28.tar.gz
- 编译安装mysql
cd mysql-5.7.28
cmake . \
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DWITH_BOOST=/usr/local/src/boost \
-DMYSQL_DATADIR=/data/mysql/ \
-DMYSQL_USER=mysql \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_ARCHIVE_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DWITHOUT_MROONGA_STORAGE_ENGINE=1 \
-DWITH_EXTRA_CHARSETS=all \
-DWITH_DEBUG=0 \
-DWITH_READLINE=1 \
-DWITH_SSL=system \
-DWITH_ZLIB=system \
-DWITH_LIBWRAP=0 \
-DENABLED_LOCAL_INFILE=1 \
-DMYSQL_UNIX_ADDR=/usr/local/mysql/tmp/mysql.sock \
-DDEFAULT_CHARSET=utf8mb4 \
-DDEFAULT_COLLATION=utf8mb4_general_ci
make -j `lscpu | grep -i '^cpu(s)'| tr -s ' ' '%' | cut -d% -f2` && make install
- 修改/etc/my.cnf文件,编辑配置文件如下
vi /etc/my.cnf
[client]
port = 3306
[mysqld]
datadir=/data/mysql
skip_name_resolve=on
innodb_file_per_table = on
port = 3306
socket = /usr/local/mysql/tmp/mysql.sock
character-set-server = utf8mb4
collation-server = utf8mb4_general_ci
log-bin=mysql-bin
server-id = 1
[mysqld_safe]
log-error = /usr/local/mysql/logs/error.log
pid-file = /usr/local/mysql/pids/mysqld.pid
- 创建log、socket与pid文件与相关存放目录,并修改权限
mkdir /usr/local/mysql/{logs,tmp,pids}
touch /usr/local/mysql/logs/error.log
touch /usr/local/mysql/pids/mysqld.pid
chown -R mysql.mysql /usr/local/mysql/tmp
chown -R mysql.mysql /usr/local/mysql/logs
chown -R mysql.mysql /usr/local/mysql/pids
- 添加PATH变量
echo 'PATH=/usr/local/mysql/bin:$PATH' > /etc/profile.d/mysql.sh
source /etc/profile.d/mysql.sh
- 初始化数据库, –initialize 表示默认生成一个安全的密码,–initialize-insecure 表示不生成密码
mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql
- 拷贝mysql.server作为mysql服务启动脚本文件
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
- 启动服务
chkconfig --add mysqld
chkconfig mysqld on
service mysqld start
- 登录mysql,修改密码
mysql -u root -p
set password for root@localhost = password('root');