mysql5.6编译安装步骤

---

下载mysql-5.6.35.tar.gz

wget -c http://mirrors.sohu.com/mysql/MySQL-5.6/mysql-5.6.35.tar.gz

准备MySQL数据目录
mkdir -p /data/mysql
chown -R mysql:mysql /data/mysql

---

用户和组

groupadd mysql
useradd -r -M -s /sbin/nologin mysql

---

安装依赖

yum -y install cmake gcc gcc-c++ apr* autoconf bison automake zlib* fiex* libxml* ncurses-devel libmcrypt* libtool-ltdl-devel*

---

安装

tar -zxvf mysql-5.6.35.tar.gz
cd mysql-5.6.35
cmake . \
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DMYSQL_UNIX_ADDR=/data/mysql/mysql.sock \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DWITH_EXTRA_CHARSETS:STRING=utf8,gbk \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_READLINE=1 \
-DENABLED_LOCAL_INFILE=1 \
-DMYSQL_DATADIR=/data/mysql \
-DMYSQL_USER=mysql

make
# 进入漫长的编译【完成的时间长短取决于机器硬件配置】

make install

---

安装完成后的配置

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

ln -sb /usr/local/mysql/my.cnf /etc/my.cnf

echo "export PATH=$PATH:/usr/local/mysql/bin" >> /etc/profile

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

chmod 755 /etc/rc.d/init.d/mysqld

service mysqld start