源码编译安装mysql5.7.28

mysql 源码编译5.7.28

• mysql源码中带boost与不带boost编译相同

1. 创建 mysql 用户

groupadd -r -g 27 mysql
useradd -s /sbin/nologin -r -u 27 -g 27 -d /data/mysql mysql 

2. 创建mysql文件的家目录用来存放mysql数据库

mkdir /data/mysql 
chown mysql.mysql /data/mysql 
	＃注意数据库存放目录必须为空

3. 安装相关依赖

yum -y install wget gcc gcc-c++ cmake openssl-devel ncurses-devel zlib-devel bzip2

4. 下载boost_1_59_0

    #MySQL5.7及以上的版本，在编译安装之前需要安装boost,因为高版本mysql需要boots库的安装才可以正常运行。
    #否则会报CMake Error at cmake/boost.cmake:81错误    
    wget http://www.sourceforge.net/projects/boost/files/boost/1.59.0/boost_1_59_0.tar.bz2 -c /usr/local/src

    #下载mysql-5.7.28
    wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.28.tar.gz -c /usr/local/src

5. 解压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

6. 编译安装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

7. 修改/etc/my.cnf文件，编辑配置文件如下

vi /etc/my.cnf

[client]
port = 3306

[mysqld]
datadir=/data/mysql      

# 禁止主机名解析
skip_name_resolve=on

# ibd文件单独存放
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

8. 创建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

9. 添加PATH变量

    echo 'PATH=/usr/local/mysql/bin:$PATH' > /etc/profile.d/mysql.sh
    source /etc/profile.d/mysql.sh

10. 初始化数据库， –initialize 表示默认生成一个安全的密码，–initialize-insecure 表示不生成密码

        mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql

11. 拷贝mysql.server作为mysql服务启动脚本文件

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

12. 启动服务

    chkconfig --add mysqld
    chkconfig mysqld on
    
    service mysqld start

13. 登录mysql，修改密码

    mysql -u root -p #第一次登陆不需要密码，回车即可
    set password for root@localhost = password('root');  #修改密码