mysql编译安装

准备：安装包 mysql-5.5.53.tar.gz或者mysql-5.6.23.tar.gz 、调通系统网络环境、配置网络yum源、本地yum源

安装：

1.创建系统组合用户

    groupadd -r mysql

    useradd -r -g mysql -s /sbin/nologin mysql

2.创建数据目录

     mkdir -pv /mydata/mysql/{data,run,logs,binlogs,relaylogs}

3.修改数据目录的用户和组

    chown -R mysql.mysql /mydata/mysql
4.安装编译安装所需软件，解决依赖关系

    yum install -y gcc gcc-c++ cmake
5.解压安装mysql

    tar -axf mysql-5.6.23.tar.gz -C /usr/local/

    cd /usr/local/mysql-5.6.23.tar.gz

    cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/mydata/mysql/data -DSYSCONFDIR=/etc -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_READLINE=1 -DWITH_SSL=system -DWITH_ZLIB=system -DWITH_LIBWRAP=0 -DMYSQL_UNIX_ADDR=/mydata/mysql/data/mysql.sock -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci

    make && make install && echo ok

6.配置mysql

    chown -R mysql:mysql /usr/local/mysql

    cd /usr/local/mysql

    cp /usr/local/mysql/support-files/my-large.cnf/etc/my.cnf

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

    vim /etc/profile.d/mysqld

    exportPATH=/usr/local/mysql/bin:/usr/local/mysql/lib:$PATH

    . /etc/profile.d/mysqld

7.启动mysql

    service mysqld start

8.设置开机自启

    chkconfig mysqld on